Invoicing package problems

[ladurande]

Hi, Am trying to write a simple invoicing program where the tables are

Customers
Stock
Order No
Order Details

I wish to make an Invoice input form by first picking the individual customer (no problem wit a combi box) and then being able to search the stock with a combi box showing record in sub form (thats OK)

The difficulty comes trying to add a 3rd. and 4th. sub form so that on requesting a new invoice the next number in the Orders table is used then the data from the Stock record selected is posted to the Order Detail table.

Sorry to be so basic but just learning 2010 access and don't seem to be able to find the answew

Thanks

 

[G37Sam]

I don't quite get why you're adding a 3rd and 4th subforum in the same form?

You'll need an OrderNo form linked to Orders Subforum via OrderID. Once that invoice is input and saved, you should move to a new record to add the next invoice.

Unless I'm missing something?

 

[ladurande]

Thanks for your reply.

I understand what you are saying but will just confirm what you are suggesting.

I make a Form with the main Table Orders.
I then have a subform for Order Details.

The problem is to start with I need to lookup (using a combi box) the customer tel no. to get the Primary Customer ID.

Then I want to create a new record for the Order table linked to that customer. (one subform)

Then I need to search the stock table using the serial No. of the product. (Thought that would need a subform)

Once selected then that stock record details copied to the Order details Table (which i thought would have to be another subform).

It seems I may be going about it the long way around wait for your reply.

(the invoice printout of course will be produced in a report from the data from that form to give to the customer)

Thanks for your patience!!

 

[Simon_MT]

The OrderId could be Autonumbered and increment accordingly.

Combi for Customer

Subform for Order_Details

Combi for Stock

Simon

 

[ladurande]

HI, Have set up form as you suggested but can't seem to get the stock item selected by the combi box to then fill a new record in the Order details subForm/table.

Think I will need some VBa code?

 

[Simon_MT]

The Stock Combibox needs a Row Source Select query.

Simon

 

[ladurande]

Thats OK but how do I link the record selected in the Combi Box to the subForm Order_details

 

[Simon_MT]

In Order_details the Stock Control should have a Row Source to Select Stock once Selected that will represent the value in Order_details.

Simon