Показать сообщение отдельно
Старый 31.05.2017, 17:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,477 / 846 (79) +++++++
Регистрация: 28.10.2006
sunilrakesh: Reference group lookup in D365 (Ax7)
Источник: 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
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.