Relational Lookup - Restrict Lookup Data

Question Status

Verified
Khashayar asked a question on 17 May 2018 1:16 PM

Hi Community, is there any possibility to restrict the relational lookup for "Vehicle Category" ?

I only want the categories to be shown once. I know since they are listed in the vehicleTable they also Show up in the same amount in the Relational Lookup, but I only then want them to be shown once, if inserted in the vehicleTable.

Reply
Verified Answer
ievgen Miroshnikov responded on 17 May 2018 4:16 PM

Hi Khashayar,

Then you need to have VehicleCategory table that has all categories and relation to this table, like

RentalTable.VehicleCategory  == VehicleCategory.Category.

Reply
Verified Answer
Sukrut Parab responded on 17 May 2018 5:04 PM

You should create a master table to store category and then Create relation with that master table to have look up on your other table

Reply
Verified Answer
ievgen Miroshnikov responded on 17 May 2018 4:16 PM

Hi Khashayar,

Then you need to have VehicleCategory table that has all categories and relation to this table, like

RentalTable.VehicleCategory  == VehicleCategory.Category.

Reply
Verified Answer
Sukrut Parab responded on 17 May 2018 5:04 PM

You should create a master table to store category and then Create relation with that master table to have look up on your other table

Reply