relationships

[Guest]

I have numerous tables where i would like certain fields to be recorded into
a single table. For example:

TblAdhesive TblProducts
AdhesiveID <-------------------> productID
projectID productname

TblSplice TblProducts
SpliceID <-------------------> ProductID
projectID Productname

I would like the adhesiveID SpliceID and projectID to also go into a single
table

TblSplice
<-------------------> TblField
TblAdhesive ProductID
ProjectID


Thanks

 

[Guest]

Swansie:

I'm not entirely sure what you're asking, but will give it a try...

I am going to make the 'assumption' that Adhesive and Splice are both
products (by looking at your arrows...)

I would suggest you also combine tblAdhesive and tblSplice, with something
like this:

tblProducts
ProductID (PK)
ProductName (Unique)

tblItems
ProductID (FK)
ProductType (Adhesive or Splice, etc.)
ProjectID (FK)

Along with your Project table, this will eliminate the need for another
table putting Product, Adhesive/Splice, and Project together. A simple query
will do that for you.

Good luck.

Sharkbyte