sunilrakesh: Reference group lookup in D365 (Ax7)

[Blog bot]

Источник: https://community.dynamics.com/membe...f-1e2bf6b676cf
==============

1. Table A (LandId Int64, Name str, Floor str)
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).






Источник: https://community.dynamics.com/membe...f-1e2bf6b676cf