Skip to main content ↑ ↓
Topic: Copy field from a look-up record into current record (Read 1259 times) previous topic - next topic

Copy field from a look-up record into current record

I am looking for solution on how to copy fields from a look-up record to the current record.
Example: Current record is a order detail line, I am doing a look-up on a product table. The Product table has ProductNo, ProductDescription  and a ProductPrice.  I need to copy the ProductPrice and the Product Description into the current record (OrderLine). Both fields must be open for edit in the OrderDetail record (i.e. the sales person should be able to modify the price in the OrderLine).
 

Re: Copy field from a look-up record into current record

Reply #1 –
Select the list view and there’s a field that says “Join” go there and select the table that has the edition all fields, select ‘inner join” and select the fields that link the two tables together. You should now have all the fields from both tables in your list. You can then select/deselect the ones you want.