I'm looking for some help as a very brand new AX user... I have created 2 Tables using the AOT that are needed for reference to our parent company system.
Table 1 is a setup table that only has 3 fields:
Type ID (enum - with only 3 values permitted)
Table 2 is another setup table that needs to link to table 1:
Group 1 - from table 1 using type id 1
Group 2 - from table 1 using type id 2
Group 3 - from table 1 using type id 3
I created a grid for Table 2 that includes all 5 fields. My problem is where I try to add a lookup to Group 1, Group 2 and Group 3. I can only get the lookup on Group 1 (or the first field in the grid) to work. Is it possible to link multiple fields to the same lookup file? My final plan is to add a filter so that the lookup will only show type 1 records for group 1 and type 2 records for group 2, etc.
Any help would be most appreciated!
It sounds like you want a similar lookup as is available for financial dimensions?
Another place to look for example is CRM module (AX2009) Customer segment / sub-segment.
Another place to look is AR Return reason groups and Return reason codes.
If I understand your question correctly then you want to have lookup on Group 1 field for all the records from Table 1 having type Id 1 and similarly look up for Group 2 should fetch all records from Table 1 having TypeId 2 and same for Group 3.
You can easily achieve this by defining normal and related field fixed relations on table 2 with Table 1 .
Another approach, In case you are using AX 2009 is that you can also define the same relation with Table on EDT and directly use it in your tables.
perform a query lookup. Examples available in may uibuilders