Simple lookup not so simple

[buck]

Hi,

I'd really appreciate an extra set of eyes on this one. I'm trying to create 4 product pulldown menus with a respective field next to each that does a lookup and pulls in the corresponding product code. The products need to be in a seperate file from the main database.

I'm very close, but when I select from the first menu, the code appears on all 4 of the code lookup fields instead of just the first. Hmmm.

Any help would be much appreciated, the small file is attached. I think the problem has to do with the relationships, but I'm just stumped.

HappyLookup.zip

Edited December 6, 2005 by Guest

[flook]

Each lookup requires it's own relationship.

This is how I did it, but I'm sure there's more ways.

HappyLookup.zip

[Breezer]

You may want to reconsider your file structure. But if this is the way you wnat it set up, try this method of using various TOGs.

HappyLookup.zip

[buck]

Those were both exactly what I was looking for. Thank you so much!