Field Lookup based on two references

[Guest_imported]

Hi all. Having problems in my database - in short: I want access to look up a value based on two parameters...the first, is based on the current customer, second, is the type of information it is looking up (ie. small, medium, large).

For example, if I select small for customer X, than a value of 1 for instance should appear, however, if i select another customer and again for small, a value of 1.5 should appear.

A problem exists in my database in that the customer ID is not linked to this table as it is linked indirectly through another table - don't know if this helps - but here it is anyway.

Thanks for the help.

Cheers.

 

[Jucius]

I had a similar quandry recently.

I ended up creating an intermediate table which summaried the relationship between (my equivalent of) the customer ID and whatever keys were in the second table. I had to merge some fields and such so the relationship could be created.

Then I was able to do an inner join between the first table, query and second table so that the relationship could be shown and data could be retrieved.