in form when i create a new record its getting inserted in the parent table but its not reflected in child table i have given relations .how to resolve this problem?
*This post is locked for comments
AX is saving records for each bound form controls. So if you have your controls linked against those 3 datasources, you should be set for the saving part.
If you want to save the records and link them, then you need to implement that yourself to initialize the field value that is responsible for the relation.
Normally it is done via a surrogate key, which is the RecId field, so child tables should be linked to the parent via RefRecId. That means the parent record must be saved first, so it does get a record identifier value allocated, after which you may populate that on the children to complete the linking.
hi ..
i m beginner to ax ..
i have created 3 tables called student details,cse,ece;
i hav created related field relation in ece cse to differentiate the dept..where dept is enum in parent student table.
and i created a form which consists of fields form all of these tables when i insert record through this form its get reflected in student details not in cse or ece ..
Hi,
Please check whether you have given the joinsource property of your childtable datasource. It should have the name of the parenttable datasource.
Hi,
What are the relations between your tables, e.g. like SalesTable-SalesLine? How do you show the records on the form, in grids, how are the datasources set? Please give some more info.
Regards,
István
#1
André Arnaud de Cal...
292,492
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
