Lookups from 2 tables

[bigmac]

Im managing a product list

table 1) partnumber, price

table 2) partnumber, price

Main table) Partnumber, description, price etc

In my main table, i create a relationship between partnumbers table 1 & 2, and I use auto lookup according to... oops, can only choose one of the to relationships.

How can I relate to both of them and make the price from both tables end up in my main table price column?

A note: there are no price duplicates between table 1 & 2

Edited January 12, 2008 by Guest

[comment]

The easiest way would be to combine the two price lists into one, of course. If for some reason (?) you must keep them separate, change the lookup into an auto-entered calculation, e.g.

Lookup ( Table1::Price ; Lookup ( Table2::Price ) )