Link tables question
I have a very basic - even maybe stupid :-p - question.
I have 2 tables : customer & invoices.
For both tables I have a Primary Key and in the invoices table, I have a Foreign Key called fk_CustomerID. Both tables are linked via the pk_CustomerID & fk_CustomerID. No other links are created between those two other tables and I do not have any other common field.
Now I would like to know how I can set up my forms in order that the tables work together : from my customer form, I would like to link to the invoices making sure that the customer information is correctly added to the new invoice.
What is the best way to achieve this?
Also, is my basic setup ok or should I add something in/between the tables?
Thanks in advance for your input!