insert data from another table

[dundee]

Hi,
Im new hier and new in Access. Lot of Excel done so far but only some Access.
Im sure it is a trivial for you but...


I have two tabels: [Orders] and [Items].
In table [Orders] column [ItemsName] is with relation to table [Items], so I can choose item and get the name of item in table [Orders].
Now the question: how to get in table [Orders] in column [Price] the price from tabel [Item] for that item?

Thx in advance

[orange]

I recommend you read and then watch the tutorials listed in this post.

Good luck.

[ranman256]

you should have a table of tInventory, in it is
tInventory
[item]
[price]

when the user picks the ITEM, you run an update query, that joins tOrderDetail to tInventory on [item], to update tOrderDetail.[price] from tInventory .[price]

[orange]

For more info on what ranman256 is saying see this video. In overview, you record the AgreedtoPrice or OrderDetailPrice in the orderDetail record so that you
-could regenerate an old order,
-do not potentially change the price on all previous orders

see https://www.accessforums.net/queries...tml#post205278 for other info.