Populating an Invoice from an underlying table.

[Evon]

As simple as it sounds. I have set up a table with a list of items and the costs. I then created a form with a list comprising 10 combo boxes. I want to be able to select one record from the underlying table per combobox on the form.

I am able to do this but the records in the underlying table keeps switching to the primary key field as I go along using the combobox.

Any step-by-step how to do this would be appreciated.

 

[Evon]

Thanks Uncle, I have been doing that. However, haven't found any quick solution yet. The examples I was looking at are a little complicated.
In the meantime I will continue searching, but hopefully someone here will have a quick fix.

 

[Evon]

This is what I have. I want to use the comboboxes in the "InvoiceForm" to get data from the "Items" table.
It is a simple setup right now but I inted to add more features, data fields and formatting further down. Just want to clear this hurdle, and I should be good.

 

[Evon]

I have just updated the database as I just realized that some of the products in the Items Table were showing the ID Numbers instead of the item names, and this is the problem I have been having.

 

[Evon]

Okay, just customized the Northwind and that will serve the purpose. Thanks all.