Testing records (1 Viewer)

rgwfly

Registered User.
Local time
Today, 07:28
Joined
Jun 7, 2016
Messages
49
I was hoping to get some help with this design. It seems so simple but can't get my head wrapped around.
design scope:

User 1 enters drawing(one) and location's(many)


User 2 finds the record and add the additional Pass and various other information.
Reports generated, boss is happy.....

I need to write a new record to the tblTest after a drawing and location is entered. there may be multiple locations and more may be added at a later date.
I though writing from the form without the relationship but do no want to duplicate drawing and location records.
I attached a simple version of what I am trying to accomplish.
Thanks again
 

Attachments

  • tmpTest.accdb
    492 KB · Views: 69

Ranman256

Well-known member
Local time
Today, 10:28
Joined
Apr 9, 2015
Messages
4,339
Are you wanting to test the drawing or the location?
Can you put a test field on either table?
Would the test be a sub table of tDrawing? Or location?
 

rgwfly

Registered User.
Local time
Today, 07:28
Joined
Jun 7, 2016
Messages
49
The location is what I am ultimately testing, however there may be the same location on multiple drawings.
the drawing & location are unique and should only have one record.
Not sure about second question I was using the WeldID as the unique identifier.
I set this up as the drawing is a sub of test; location in a sub of drawings.
I guess the other way around may work. The user 1 will enter many drawing locations that may never need the test done though. the database is based on a sampling rate.
Thanks for the reply
 

Ranman256

Well-known member
Local time
Today, 10:28
Joined
Apr 9, 2015
Messages
4,339
then the tTest table would be on the location
TestID, LocID, DrawID, Result

then all locations for that drawing would have the same test result.
 

rgwfly

Registered User.
Local time
Today, 07:28
Joined
Jun 7, 2016
Messages
49
Exactly what I don't want.
I was thinking of using a form to write Drawing & Location to the table (tbltest). in essence to create the test record.
I would somehow need to prevent it from being duplicated if another location is added to the drawing table.
 

Users who are viewing this thread

Top Bottom