Multiple data entry from one form

[Chimp8471]

I have a very simple database that keeps a track of line performance figures, i have attached a part of it as an example:

In my lines table are 8 production lines

in my log table i need to keep a track of the data,

what i would like to happen:

i need a form that when i open it all the production lines i have are displayed and next to each line are 2 data entry fields so i can enter a performance and an output figure for each line in one go, so in this instance i would like 8 lines and 2 entries per line.

at the moment i have to do each line individually.

i would also like this to grow should i add more lines

how can i best sort this please.

Help would be much appreciated

Andy

 

[agehoops]

Do you just want to edit those 2 fields on one go? and do you only want those 2 fields of each line visible? Or do you want it to show you every single bit of information for ever line, and then have 2 fields to enter data in which will edit that field for all of the lines?