>>>I am using 3 different tables trying to add records. When clicking on new I add a unquie customer number to the parent table how. How can I get that customer number into the child tables when adding a new record?
>>>
>>>Thank you
>>>
>>>Holly Clawson
>>
>>
>>How are you adding the unique ID to your parent table? Are you using the INSERT trigger or you doing it programmatically? Have you tried something like this...REPLACE child.uniqid WITH parent.uniqid?
if parent - child relationship is 1 - many, this won't work. i call a function from the default value set (vfp 5) that gets the next avail unique number from a unique number table...