AnsweredAssumed Answered

Link tables question

Question asked by FredH on Oct 31, 2014
Latest reply on Nov 1, 2014 by FredH

Title

Link tables question

Post

Hi Experts,

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!
Kind regards,
_Fred_

Outcomes