Value lists and look ups

[bigdan]

Hello,

I have a value list set up from field size in table "sizes" which only has 3 fields (size, rate, idnum) and when I choose one of the size values i want it to look up a value from that same record, but it doesn't seem to do so... i have idnum and rate set to look up from "sizes"....

is this making any sense, i'm a newbie. thanks for any clues.

Dan

[bigdan]

I just tried it using the idnum as the valuelist, and the size and rate as lookups and it works that way, but I need to see the size to choose, not the id number.... anyhoo

[-Queue-]

Are sizes unique? If so, do you have a relationship from the current table to the Sizes table, based on the Size field? If so, then your lookups should work, if you are looking them up based on the relationship to Sizes.

[bigdan]

Thanks so much. Worked like a charm... the only relationships I've done are through id numbers, so i wasn't thinking that through very far! that's why it wasn't working.