buck Posted December 6, 2005 Share Posted December 6, 2005 (edited) 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 Link to comment Share on other sites More sharing options...
flook Posted December 6, 2005 Share Posted December 6, 2005 Each lookup requires it's own relationship. This is how I did it, but I'm sure there's more ways. HappyLookup.zip Link to comment Share on other sites More sharing options...
Breezer Posted December 6, 2005 Share Posted December 6, 2005 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 Link to comment Share on other sites More sharing options...
buck Posted December 6, 2005 Author Share Posted December 6, 2005 Those were both exactly what I was looking for. Thank you so much! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6710 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now