This post include Form Design and development using primary key and foreign key table relation in Microsoft Dynamics Axapta. 2012 r3 Module.
How to Add primary key in table first you need to create unique key field let id is key field name for your table.
Add index with allow duplicate no property to make it unique key .
then add relation in tables(foreign key and primary key) as shown in below video clip.
Create another table for foreign key relation then add normal relation in second table.
To show data in form Add table to form datasource and set required properties in data source as shown in clip.
You seen how its works table data on form .
How to Add primary key in table first you need to create unique key field let id is key field name for your table.
Add index with allow duplicate no property to make it unique key .
then add relation in tables(foreign key and primary key) as shown in below video clip.
Create another table for foreign key relation then add normal relation in second table.
To show data in form Add table to form datasource and set required properties in data source as shown in clip.
You seen how its works table data on form .
Thanks for viewing and watching if you like it please subscribe to get next video update and learning.