SBX - Search With Button

SBX - Forum Post Title

Relational Lookup - Restrict Lookup Data

Microsoft Dynamics AX Forum

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

Question Status

Verified

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

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

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

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

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

SBX - Two Col Forum

SBX - Migrated JS