Invoicing Database

[ladurande]

Hi, wish to design an invoice package but have problems on setting up a Master Form and subforms .

Tables created

Customer
Stock
Order No.
Order Details

I wish to open an invoice form and do the following:-

1 - Select the customer via a Combi and display details (no problem) Master form

2 - Select the item in the Stock table with a combi (no problem)

3 - Add the details in the selected Stock combi to an Order Detail subform in the Master form. This action may be repeated if multiple items are selected by customer.

4 - When all selected be able to view a preview of an invoice report with options to either accept or reject. If rejected all selected item fields in the new subform cleared and if accepted option to print Invoice and then up date the relevant tables.

Have no problem with items 1 & 2 but can't crack the selected stock item to a sub form.

Help!!!

 

[pbaldy]

Typically you'd have a combo in the subform that was bound to the order details table (control source) but got its selections from the stock table (row source).

 

[YNWA]

Try the Northwind template within Microsoft Access.

 

[ladurande]

Thanks Paul,

Got this to work but it only adds the 1 field that I selected from in the combi box into the tblOrder Details although I have added the fields I require when designing the Combi box.


Alf

 

[pbaldy]

See if this helps:

http://www.baldyweb.com/Autofill.htm