Setting up an order form

[gabowers via AccessMonster.com]

I am trying to set up an order from that will enter multiple lines to my
"transactions" table. I have 1-5 different items that a customer my get. I do
not want to input the customers name etc more than once but need it on each
line of the transactions table. Could someone give me some info on how to get
started? Maybe with the item information in a subform with the customer info
on the main form?

 

[John W. Vinson]

I am trying to set up an order from that will enter multiple lines to my
"transactions" table. I have 1-5 different items that a customer my get. I do
not want to input the customers name etc more than once but need it on each
line of the transactions table. Could someone give me some info on how to get
started? Maybe with the item information in a subform with the customer info
on the main form?

Well... yes, exactly.

Take a look at the Orders form in the Northwind sample database for an example
of just what you're talking about.

 

[Steve Schapel]

Gabowers,

Just take a step back from the forms at the moment, and get the Tables
right first.

Sounds like you need a table for the Customer details. And then you
need a separate table for the Transactions. In the Transactiosn table,
there will be *a* field to identify the customer that each transaction
pertains to. The value that is entered in this field will be the value
of the Primary Key field in the Customers table for the applicable
customer. This means there is a one-to-many relationship between
customers and transactions, and so this should be modelled in your table
structure. After that, you can set up your forms accordingly... and
yes, when you get to that step, the idea of a main form for Customer,
with a Transactions subform, sounds like a good approach.

 

[gabowers via AccessMonster.com]

What I have decided to do is start my DB over. I started it when I knew
little about Access. It is time to start from scratch to eliminate the bad
things I did a long the way. That way I will be re-alining my tables and
should be able to make things work like they do in the examples you all have
given me. Thanks for the help.

 

[Steve Schapel]

Gabowers,

Sounds great. Best wishes with the project. Please don't hesitate to
ask if you need any help.