Create order - Forms basics

[BigAl.NZ]

Hi Guys,

I have a database with tables:
Customers
Order
Order_Products

I need to create a form for entering a new order.

Essentially it needs a way to select the customer who the order is
for.

And then it should have some sort of list/table where I can add a new
line for each item on the order.

Can someone please give me a detailed insight into how to do this?

Thanks in advance,

-AL

 

[John W. Vinson]

Hi Guys,

I have a database with tables:
Customers
Order
Order_Products

Surely a table of Products as well...!?

I need to create a form for entering a new order.

Essentially it needs a way to select the customer who the order is
for.

And then it should have some sort of list/table where I can add a new
line for each item on the order.

Can someone please give me a detailed insight into how to do this?

Put a Combo Box on the form to select the customer from the Customers table.

You might want to look at the (flawed in some ways) Northwind sample database
for some structural ideas. It does exactly what you're proposing.

John W. Vinson [MVP]

 

[Al Grant]

Surely a table of Products as well...!?

Yeah thats coming - the problem is the list of products comes from about 6
different places and I am having trouble getting them all to import into
access ok from csv/excel files.

Put a Combo Box on the form to select the customer from the Customers table.

You might want to look at the (flawed in some ways) Northwind sample database
for some structural ideas. It does exactly what you're proposing.

How do you add the "control" that lets you enter a list of products against
a order?


Cheers

-Al