add orders to a bill

  • Thread starter Thread starter Wouter
  • Start date Start date
W

Wouter

Hi,

I cant find a solution for the following matter (I dont yet have much
experience in working with Access):
While making a new bill with a form, I want to select a customer from my
database and only the orders that are not yet on a bill, should be on the
new bill.
The table I have now are Customers, Bills, Orders, OrdersOnBill, Bills. I
suppose the form should add records in OrdersOnBill so that all the orders
are related to a bill. But I dont have a clue how to do this in Access, do I
need an append query to do this?

Thanks for helping me in the right way

Wouter
 
Wouter said:
Hi,

I cant find a solution for the following matter (I dont yet have much
experience in working with Access):
While making a new bill with a form, I want to select a customer from my
database and only the orders that are not yet on a bill, should be on the
new bill.
The table I have now are Customers, Bills, Orders, OrdersOnBill, Bills. I
suppose the form should add records in OrdersOnBill so that all the orders
are related to a bill. But I dont have a clue how to do this in Access, do I
need an append query to do this?

Thanks for helping me in the right way
Click to expand...
I assume that you have a form with Bills as the source and a subform with
Orders as line items.
If not this is usually the best way. The Northwind data base has examples.

Get rid of the OrdersOnBills. It is a *very* bad idea and will cause grief.

Add a "yes/no" field to Orders and call it OnBill or something.

Your Bill forms and reports would be based on a query with OnBill criteria
set to true.
 
Back
Top