>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?