The Big Bear Posted October 23, 2007 Share Posted October 23, 2007 Hi all A simple lookup has me baffle to no get out. I have delete every table and have start over three times and have spent four hours today on this so I hope some one can find where I am going wrong. The bolt table is where I stored the bolts information. The Job_bolt table is where I want to stored the bolts required for a specific job. The vessel table is the input table. I make a relationship between the vessel table and the job_bolt table using the quote field. I make a portal using this relationship. I aslo made a relationship between the Job_bolt table and the bolt table. The job_bolt table is where I want to do the lookups. In the vessel table input I attached a drop down list to a field that displayes values from the bolt table that will be stored in the Job_bolt table and this field is use for the look up. But the look up dispalyes that there is no exact match. How can this be since the drop down list is populated by the field in the bolt table. I have attached a copy of what I am trying to do. This is very aggrivating. this should be so simple. Open the vessel file first. Thanks Lionel QUESTION.zip Link to comment Share on other sites More sharing options...
LaRetta Posted October 23, 2007 Share Posted October 23, 2007 I aslo made a relationship between the Job_bolt table and the bolt table. I don't think so. You also need to use proper keys. Instead of calling it unique, it should be JobBoltID or something similar. And it should be BoltID in Job_bolt table joined to BOltID in Bolts table (which would replace THAT uniqueID). You have no BoltID in Job_Bolts that I can see. Using 'unique' is very confusing, as you've just found ... Link to comment Share on other sites More sharing options...
aldipalo Posted October 23, 2007 Share Posted October 23, 2007 Also, I noted in the Look Up table that there are no related tables chosen. I believe you need to have a relationship in order to do a look up. But, ditto on what LaRetta said. Your ID's and relationships just aren't there. Link to comment Share on other sites More sharing options...
LaRetta Posted October 23, 2007 Share Posted October 23, 2007 Hi Lionel, I would also ask ... why do you have 3 separate files instead of having 3 tables? Or even just a UI and a data file? It is soooooo much easier to work on (particularly if the developer is less than Advanced). You are very early in your design - it's not like you're building on an existing or converted solution. It's just a suggestion to make your life easier. :wink2: Link to comment Share on other sites More sharing options...
The Big Bear Posted October 24, 2007 Author Share Posted October 24, 2007 LaRetta Thanks for the information. will take your suggestion. Thanks very much Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6164 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