Enter multiple records in 1 form?

  • Thread starter Thread starter Mike D.
  • Start date Start date
M

Mike D.

Is there a way to enter multiple records in 1 form?

I want sort of an Excel style form that would show the
following -


| Date | Machine# | Machine Speed |
-------------------------------------
| date() | 55 | (user entry) |
| date() | 56 | (user entry) |
| date() | 62 | (user entry) |

______________________
|ENTER RECORDS BUTTON|
----------------------


Can all records be entered in at 1 time from the same
screen with machine#s already listed as shown above??

It would seem a little redundant to make the user choose
the machine# from a picklist, have them enter the machine
speed, then click to enter the record for each machine
separately.
 
Use an append query to add the records for each machine and the dates, then
display these to the user for them to enter the machine speed.
 
I solved my own problem. I didn't think to just add a
separate entry for EACH machine speed in the table and
have it as 1 record. duh!
 
You're original design was better. In the "new" design you have denormalised
the table, and are storing data in field names, which is not a good idea.
 
Back
Top