If you enter a part number that does not exist in the lookup table, the lookup fields will not be populated.
If you leave the part number empty, it will not lookup values either.
So what is the problem with using lookups?
Right now how I have it, if I type in any field that relates to any other field any way based of the parts database it will auto-enter the fields, I want this to only happen if I type in a part number, I dont want it looking up information if I don't have a part number.
What is the correct way to setup a lookup?
I really can't understand what you have set up. Are you seeing fields being populated in the table you are in? And what table is that? Or are you seeing related data from a parts record? It seems strange to type in "any field that relates to any other field any way based of the parts database" and that triggers a lookup? Do you even have lookups set in the field options?
Sorry I'm not very clear on things. I'm obviously a n00b to FileMaker.
Here is a screen shot of what I am working with. If you want to see my files that i am working with I have posted them to brentnelsonmedia.com/filemaker there are 3 databases linked. Avery Part Number is pulling from Avery database.
Thank you for trying to help me!
Wow, OK I would never have guessed what the problem was by looking at the screenshot.
Your relationships are wrong. Very wrong.
You have (or someone has) related all the Avery fields to all the Job Setup fields with a cartesian join.
What could work with your current setup is to relate:
JobSetup::Avery Part Number = Avery::Number
Then the fields like Size AC will lookup their values when a part number is entered and not unless.
See if that makes sense for you.
BTW, all these tables could be in one file - that would make things a lot easier.
Awesome! Thanks! that works for me. I feel stupid, I should have thought of that.