Re: R&D database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Angel G" <Nomail@xxxxxxxxxx> wrote in message news:O6o9oK5$HHA.536@xxxxxxxxxxxxxxxxxxxxxxx
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!




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

.