Inserting records VIA form

[jamesmor]

Hey guys, got another question for you.

I have a table that has the follow fields (this is for a mailing schedule)

Job Name, Mail Date, Job Number, ID #, Material Due Date, Quantity To Mail

Here's the problem I'm having.

For each "Job" that we have, it can have multiple "Mail Date(s)". I'm trying to create a form that will allow a person to enter one "Job Name" and multiple "Mail Date(s)" and have it create a total number of records based on the number of "Mail Date(s)" (total possible is 4). Example below.

I'm creating a mailing for "Free Hot Coffee", I enter the "Job Name" once, and enter 4 "Mailing Date(s)", then click a button and have Access add 4 records for "Free Hot Coffee" each with a separate "Mail Date"

Is this possible? If so how? I was thinking of using a For loop but didn't know if it was possible.

Thanks in advance.

 

[ScottGem]

You should have a jobs table and a mailings table. Then use a mainform/subform to enter multiple mailings in the subform.

 

[jamesmor]

inserting records via forms

would the "Mail Date(s)" be listed in the main form with "Job Name" in the sub form, or the other way around?

 

[ScottGem]

The many side (therefore the mailings as I said) go in the subform.