45
Hi
I need to update address of parent table from child table fields.
I have written find method in parent table.
fields in parent table are - cusID, address, name
fields in child table are - street, state, zipcode and Isprimary::noyes
so if i select Isprimary to yes in child table all the fields of child table should update in parent table address field
i kept releation as foriegn key relation(RecId relation) in child table
*This post is locked for comments
I have the same question (0)
Hi,
You can default details on the parenttable by calling the parent table find method in the validatewrite of the child table datasource on form like.
parentTable parentTableLocal;
# file
super();
if (childTable.isprimary == true)
{
parentTableLocal = parentTable::find(childTable.parentRecId);
if(parentTableLocal.Recid)
{
ttsbegin;
parentTableLocal.selectforupdate(true);
parentTableLocal.Address = childTable.Street + #delimiterSpace+ childTable.State + #delimiterSpace+childTable.zipcode;
parentTableLocal.update();
ttscommit;
}
}
Here I assume you are updating the address field of parentTable from childtable fields and not from standard ax address tables.
Hope this helps you.
Thanks,
Chaitanya Golla
Share
Report
All responses (
Answers (
