Filling up a table from another

[prabirsenuk]

Hi all:

I have an inventory table, and I wish to pick items from that inventory table and populate an order placement table.

In oracle, clicking one of the item windows in the form provide with a LOV (List of Values), and usually items are picked from there.

How do I achieve this in Access, and it does not have to be LOV as in Oracle.

I shall be thankful for your kind help.

Regards - Prabir.

[MStef]

1) You don't need the same data in two tables !!
2) If you want to do this, try with Append query.

[prabirsenuk]

I do not wish to append. I want to pick and choose the items I want to order abd populate my order placement table.

For example, the inventory table would have

Item Code
Item_description
Item_price
etc etc

I want to choose the iems I want to oeder from the Inventory table and prepare my order placement table.

Thanks -

[MStef]

1) As I said before, you don't need the same data in two tables, (only foreign key).
2) If you want it, try to do it with Update query.

[neileg]

You can't do this at table level, you need a form. You could use a combo box or a continuous form to show your list of values.