Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
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.
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.