2.Table B (LandId Int64, Description str)
Need Table B field LandId & Description as lookup on Table A LandId.
3. On Table B :
Fieldgroups:
AutoLookup:
LandId.
Description.
AutoIdentification:
LandId.
Index:
LandIdx->LandId.
Index Properties:
Allowduplicates: No
AlternateKey: Yes
TableB properties:
ReplacementKey: LandIdx
4. On TableA:
Give relation LandId to RecId of Table B.
5. Form with Table A as Datasource:
Drag LableId field on to grid. Will notice that field with reference group.
Properties of reference group:
DataSource: TableA
Reference field: LandId
Replacement field group: AutoIdentification (u can give your own group).