random976 Posted December 10, 2008 Share Posted December 10, 2008 hello, I am having trouble looking up values from other tables, in the ISSUE table, I want to select a the tech name field and have the field TECH NUMBER be populated, the data comes form the TECHS table, but I just can't get it to work, thank you ALLTECH.zip Link to comment Share on other sites More sharing options...
LaRetta Posted December 11, 2008 Share Posted December 11, 2008 Your relationship from Issues to Tech Names should only be based upon Tech Number. You don't even need the field Tech Name in Issues at all! Either change your value list to a pop-up (which will always display the Tech Name after selection or place your Tech Name field (from Tech Name table) directly on your Issues layout. It's the power of relational - no need to have the Tech Name in both places. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5753 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