Does the table that has the part numbers also have data that you are trying to match, i.e, Product Line, Make, Model, etc., etc., fields? If it does, then you must create 1 relationship based on Product Line = Product Line, Make = Make, etc. Your lookup should be based on this relationship. When all 6 in one table match the same 6 in the part number table, as long as the match is unique, the part number should get looked up. However, it would seem the lookup should go the other way, meaning that you enter a part number and the Product Line, Make, etc., data gets looked up.
Did you define your value lists properly?
Anyway I think that there's something that you're doing totally wrong.
Some more info please or a test file so we can look at what's wrong (data is not needed):
Do you try to find it via the relationships when the layout is in browse mode or by entering find mode or via a scripted find?
Are the dropdown fields based on the parts table actual fields or global fields?
I defined the value lists properly and I attempt to find the info in browse mode....I am wondering if I need to make the part number field a Portal Tool? I now have the options displaying in the drop down fields and am able to put in all the specs of my vehicle. However, the part number still isn't being displayed. (FYI my part number field is an Edit Box).
Thank you so much for your help!
The table with the part numbers also includes the data that I am trying to match and I have the relationships linked yet the part number does not pop up in the part number field when I enter all of the specs of a vehicle....
Thank you for your response.
If you think you have the relationship set up properly, put a portal on the main table layout that looks at the Part number table based on that relationship. Put the Part Number field in the portal. If your relationship is correct, each record in the main table should show the Part number in the portal. If there is no Part number, your relationship, or your lookup, is not correct.
Is it possible that there is more than one part number that corresponds to each 6-field combination?
Post the file so we can have a look
Did you enter Find Mode before entering your search criteria? From your description it isn't clear to me.
Post a picture of your TO connections, at least. Without seeing anything it’s difficult to help.
Make sure your fields are indexed, by the way.
you might consider a single record portal (filtered by your criteria, upon clicking "find")
Thanks so much! Based on the guidance you all provided I was able to get the tool up and running so that it pulls the part numbers. Now I am trying to package it into a standalone file so that I can distribute the tool in a way that others can download it. I will be using Advanced installer to do this but in order to do so I need to convert and package all of the files associated with my look up tool into sav. format
If the problem stated in the original post has been solved and you have another unrelated question you should start another thread.
Seems like you now want information on how to create a run time.
FYI FIleMaker Run Times are slated for deprecation sometime in the future