Lookup in List and View pages

February 06, 2021, 07:31:23 PM

Hello,
i have 2 tables, let's say cars and tables, with this sample data:

(`ID`, `CarName`, `Tyre`)
(1, 'Renault Clio', '2'),
(2, 'Nissan Juke', '3');

(`ID`, `TyreModel`) VALUES
(1, 'Pirelli xyz'),
(2, 'Michelin 180'),
(3, 'Michelin 220');

In Add and Edit pages the lookup works perfectly. I was even able to lookup two and more tables with inner join.
But when it comes to List and View pages, there is no auto lookup, nor something to set in the Tyre Field Property.
Obviously there is no lookup in the published page

In the List Page Properties there is a field to set a join, but it add an inner join with no custom editing possible.
SELECT * FROM cars
INNER JOIN tyres ON cars.Tyre=tyres.ID
This adds other fields to the table than have to be unselected.. and is not very easy when tables have many fields
Are there others way to get a simple lookup in the List and View pages?

Thanks and best regards
Juri Bertello

Re: Lookup in List and View pages

Reply #1 – February 12, 2021, 07:53:47 AM

@JuriB You could use page events to write a code to get the data you Want and then assign it to the record variable so that you can use it on the view page. Here is a sample video doing what I described. https://youtu.be/W0tsxWBHuqU