R&D database

  • Thread starter Thread starter Angel G
  • Start date Start date
A

Angel G

I would like to create an R&D database with the following:
I want to create a Tests table, PartNumbers table, PartNumberTests table and
a Results table.
We will enter tests in the tests table, and part numbers in the PartNumbers
table. then we would like to assign tests to a partnumber in the
partnumberTests table. Up to here I have no problem doing this via forms and
creating whatever is necessary (relationships, queries, etc). Then We would
like to call up a form that would display a part number and its related
tests and empty fields so that results can be properly recorded (into the
Results table). This means that the results table has to be opened with as
many new records as tests are required. Can this be done? What is the best
approach!
 
Angel G said:
I would like to create an R&D database with the following:
I want to create a Tests table, PartNumbers table, PartNumberTests table
and a Results table.
We will enter tests in the tests table, and part numbers in the
PartNumbers table. then we would like to assign tests to a partnumber in
the partnumberTests table. Up to here I have no problem doing this via
forms and creating whatever is necessary (relationships, queries, etc).
Then We would like to call up a form that would display a part number and
its related tests and empty fields so that results can be properly
recorded (into the Results table). This means that the results table has
to be opened with as many new records as tests are required. Can this be
done? What is the best approach!
Click to expand...

This is essentially a survey database - questions need answers. Check out
"At your survey" here

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

or drop me a line and I'll send you a simple survey db that I set up for a
friend which might point you in the right direction.

Keith.
www.keithwilby.com
 
Back
Top