Not sure if this can be done with forms or not...

[bovinda]

I'm trying to create a form that will let me enter an ID number and several pieces of data (that will all be recorded in table 1), and then let me record orders for this ID number (but in a separate table, table 2). I then wanted to see if there was some way to make a check box or something on the form so that I could add multiple orders to this ID number (so after each order, I would check the box or press the button again to generate more space to enter a new order record, and then I'd just stop pushing it when I'd entered them all). Each subsequent order would be added as a new record under the same ID number in Table 2.

The way I see it, doing it this way would make it so I don't have to enter the subject number every time I want to enter a new order, and I could use one form instead of two

Is this possible? Or is using a two-form method the best way? I'm completely new to Access, so I really appreciate any possible help. Please let me know if I can clarify or be more specific.

Thanks!

 

[pbaldy]

You have what sounds like two tables with a one-to-many relationship on the ID number (like customers and orders). A common way of working with them would be a form and subform in continuous view, where the form is bound to customers and the subform is bound to orders. Master/child links keep them in sync with each other.

 

[bovinda]

You have what sounds like two tables with a one-to-many relationship on the ID number (like customers and orders). A common way of working with them would be a form and subform in continuous view, where the form is bound to customers and the subform is bound to orders. Master/child links keep them in sync with each other.

Thanks pbaldy, that sounds exactly like what I'm looking for. I'll start trying to read up on those things a bit, then I'll post back with more questions.

Would that also work for the multiple orders thing? So I could just keep adding orders to the same master form somehow?

 

[pbaldy]

You would keep adding orders to the subform. In continuous view, it would list them all. Think of an invoice, where the main form is the basic info and the subform is the line items being purchased.

 

[bovinda]

Thanks pbaldy, I'm trying it out now. Appreciate the help!