missing gif attachment replaced by following text

D

David G.

Couldn't attach gif, so I'm writing out the pertinent details of my
database. This message is the second part of "Many to many (join
table) with one-to-one table added as updatable recordsource for form"
message.

tblMaterial
--tblMaterialID PK
--tblMaterialName string
--tblCategoryID FK
--tblTypeID FK
--tblBrand FK

note: The FK fields above are only for organizing and filtering the
many material records when tblMaterial is used as a record source for
a control.

jtblMaterialTestType
--jtblMaterialTestTypeID PK
--tblMaterialID FK
--tblTestTypeID FK
--jtblMaterialTestTypeTarget number:long

tblTestType
--tblTestTypeID PK
--tblTestTypeName string

tblSample
--tblSampleID PK
--tblMaterialID FK
--tblSampleDate date

jtblSampleTestType
--jtblSampleTestTypeID PK
--tblSampleID FK
--tblTestType FK
--jtblSampleTestTypeValue number:long

Note
1. linked fields have the same field name. ie tblSample.tblMaterialID
FK is linked to tblMaterial.tblMaterialID PK.
2. All links are 1:n
THANKS!
David G.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem designing a form envolving many-to-many relationships 3
Sorry to repost, but I cant get Agent to include the gif file. - relationships.gif (0/1) 2
Resend. Attachment didn't send the first time. - relationships.gif (0/1) 0
Try again - relationships.gif (0/1) 4

Top