Dynamics Community Forum Thread Details

New Learner - Trying understand lookup

Please help me confirm if i understand concepts right,

1. Table Contact has a field CustomerNo that refers/relates to another table Customer through TableRelation Property (specifying table name, and optionally field name (No), filter, condition)

2. Table Customer has property LookupPageId property set CustomerList. This implies that whenever ANY page opens that is bound to Contact table and has field CustomertNo enabled, when that field is tried to be looked-up, the CustomerList page shows up. What shows up in CustomerList when looking-up, depends upon if a FieldGroup is defined for Customer table or not.

Please clarify,

1. What is a FieldGroup? Can we define multiple FieldGroups for a table?

2. What is significance of setting Name as "Dropdown"? Can we set a different name?

3. Am I right to say, if a FieldGroup is defined for a table, the fields enlisted there would show up when this table is looked-up, or else only two fields would be shown (Id and description)?

1. What you have understand is correct. What happen in this is that developer has set the relation (Link) to a Customer table by mapping the No. in the customer table with No. in the Contact table. By doing this we can tag a customer No. to the contact record.

2. In the table customer lookuppageID is set to customerList. That means whenever the table relation is set to customer table ( if you see the arrow shaped icon in any field) and when the user press F6 to lookup this page will get open.

FieldGroup

In RTC some fields are enabled to filter and when u type the table will get automatically filtered and drop-down control will display the data from the source table. As a example when you type a item code in the sale order lines it automatically show the results in a drop down list. If you have not define any fieldgroups in the table, only the primary key and description fields will show.

DropDown is a key word and you will not be able to change it.

Yes you are correct. :)

Hope this would clear your doubts..

If you have any question please feel free to ask :)

Quick Links

Leaderboard