One to many or Many to many??

[djspod]

Hi,



Am I over analysing this DB Relationship or have I got it right first time?

For example, the tblQualityReportData can have several ID reports which will consist of different products, 1 product per ID record.

But over time there can be many products featuring in the tblQualityReportData table, is this a Many to many table?

I'm starting to think that I am overthinking this and going mad!

Any help would be appreciated.

Thanks

Darren

[ssanfu]

Seems OK to me.

I *would* make a couple of changes.
In tblQualityReportData, the field "Product Description" field in not needed.
In tblStaff, I would have fields "EmpFirstname" and "EmpLastname", instead of "EmployeeName". It is easier to combine names, rather than split them.


Have you tried manually creating records to see if the design is functional?
Are there fixed "TraceabilityCodes". Maybe need another table.

[djspod]

Thanks for your help Ssanfu, I had completely lost my way with DB this weekend.

Now back on track, the form and table are now functional as they should be.

I have made the changes as suggested.

Thanks

Darren

[ssanfu]

Excellent! Glad we could help...