Greetings all, i have a situatation that it goes like this...

Using A59, i have created two (2), SQL-based, active linked tables.... they are both originally related at SQL server backend on common key with referential integrity enforced .... then at A59, i created a set to link both actively-linked tables on the same fields..... using the default form for the newly created set, u can see the data from both tables in a parent-child format.... Now, i could UPDATE, DELETE, and even INSERT child-related fields for any particular parent record which they would successfully be persisted all the way to back to the backend SQL.... HOWEVER, upon saving newly INSERTED child records, the key field value always equates back to Null and hence the parent record can no longer link to these newly INSERTED child records.

note..... all other inserted fields in child tale are intact and persisted at SQL server, except for the key field linking it to the parent table....

would apprecite any help...... thank you....