Autofilling records

[diversoln]

I'm interested in automatically filling some records in a very simple table with the following fields:

date, facility, part type, quantity.

There are 5 facilities and 7 part types possible. Therefore, each day I need to enter 35 records (quantities of each of the 7 part types for each of the 5 facilities). I'd like to have a facility table for the 5 possible facilities and part table for the 7 different part types. Its possible that the number of facilities or the part types may change over time - if they do, the total records needed each day will be something other than 35.

When opening the form for the first time for a given day, I'd like to run a routine show all the new records with the date, facility, part-type pre-filled and the quantity field set to zero - ready for the user to enter the actual quantities. I'd like just the records for the current day to show on this form (probably with a scroll bar to see them all).


Is there a way to read the master tables for the facilities and part types and have the routine automatically pre-fill the records such that all have the current date and there is one record for each of the facility / part-type combinations?

Any suggestions?

(If this looks familiar, I posted a more broad question on setting up a form to do this yesterday, but I think this narrows down the question a bit.)

Thanks in advance for your help !

 

[doran_doran]

set the default value...

I did not read your question all the way. But this is what I did to populate a default value in a record.

Open you table in design mode, then go the field you want to populate a default value. In the default value put anything. like Mike or Cindy. Check it out. This will put whatever value you assign to all your new records.

or whenever you create a record this value will be automically populated.

good luck

Dianna