One-to-many relationship

[radek225]

In many-to-many relationship should be 3 tables.
But in my case:
1)tblValuation
2)tblInvoice

One Valuation could has one or many Invoices
One Invoice could has one or many Valuatons

How should I create relationships between these tables?

 

[namliam]

No, a one-to-many relationship should have 2 tables.

A many to many should have 3 tables.... with a so called junction table in the middle managing the many to many on both sides with a one-to-many

tvlValuation

tblInvoiceValuation

tblInvoice

 

[radek225]

No, a one-to-many relationship should have 2 tables.

A many to many should have 3 tables...

Yes I mean it but wrote something else Sorry.

 

[namliam]

Did I then supply your needed answer or not ?

 

[jdraw]

Here's a video re Junction Table