Using one field in an access database to populate other fields

[rhyds]

I'm having trouble working out in my head how to do this. Basically I have an order/invoice table where an ItemID from an items table is selected from a lookup, what I want to happen is that the item description and price fields are populated from the same items table so I can calculate totals etc. Any Ideas?

[rhyds]

Fixed it now, apparently you can use [comboboxname].[columns](2) (where 2 is the zero-indexed number of the column that has the data you want in it) to pull data out of a lookup field's combo box.