Variable input form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form that will allow me to vary
the number of input values based on the type of tool I
have. One tool requires 30 (3x10) readings the other
type requires 10 (1x10).

The table structure is
ToolID (PK)
ToolName
Reading
Date default=now()

Am I going about it wrong? Thanks for any help.
 
You need two tables. A table for the Tools

ToolID - primary key
ToolName

and a table for the Readings
ReadingID - primary key
ToolID - foreign key to tblTools
Reading
Date

Then you set up a form to show the Tools, and a subform within it to hold
the Readings. Link the forms by the ToolID. Then you can have any
arbitrary number of Readings for each Tool.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top