Question in term of designing a form

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

To whom it may concern,

I am designing a form in Access where the employee tests
a product and enters input on each products tests
results. They also enter a Serial number of each product.
How do I design the Form so that I can enter a specific
Serial number of a product and all the information
pertaining to the employee's test results appear.
 
To whom it may concern,

I am designing a form in Access where the employee tests
a product and enters input on each products tests
results. They also enter a Serial number of each product.
How do I design the Form so that I can enter a specific
Serial number of a product and all the information
pertaining to the employee's test results appear.
Click to expand...

Create a Form based on the product table, with a Subform based on the
test results table, using the Serial number as the master/child link
field.
 
Do you know about "normalization"? If not, you should start by understanding
that topic. Otherwise, you will not design your tables properly. You must
design a set of normalized tables before you even >think< of writing your
forms & reports.

Start here for a dry but instructive read:
http://support.microsoft.com?id=100139

HTH,
TC
 
Back
Top