Cheong ---
In summary:
Your solution involves two areas: You need to put these two tables into a database, and "draw" the relationship between them for referential integrity. Then, you need to define an INSERT trigger for customer that adds a record to installment. Finally, in the form, you need to set a relationship in the DataEnvironment between these two tables.
>I have a problem. I have create two table, and I wish to put these tables inside a form.
>
>Table1 is a customer data table
>Table2 is a instalment data table
>both with a "customer" primary index key
>
>the relationship is a one-to-one
>but, I am not sure how to coordinate with these two table.
>I want to make sure that when I create a customer record inside table1 using the form, there will be also a customer instalment record in table2.
>
>And when I browse around the form, the pointer in table1 will be be at the same position as the table2.
>
>Thank you.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05