Let's deal with problem one first: "I have created foreign keys(fk) and the do not pull the data unless i use the key fields specifically. It will be hard to remember all the fk's, and it is a waste of time to always have to look up the key every time."
Make your value list a two column value list. Put the key value in column 1 and the name value in column 2. You can place the name field from the related table next to the drop down field so that the name appears when you select the ID and Name from the value list.
You can also build a "name search" field and script that allows you to use filemaker's auto-complete to search a table for matching names and then put the ID of the found record into your key field. If multiple matches are found, the script pops up a list of names with additional data (so you can determine which record is the one you want) for the user to select from.
Thanks Phil, the first part is done. I knew that is what you were going to say that. I just thought there was maybe another way. The search script is something i will have to figure out. I will wait for the second part.
I'm not sure I follow your description for problem 2. I think you are describing a conditional value list. This is how I read your description:
You want to be able to select a business (Ragione Sociale) and see only the names (Cognome) that belong to that business. Correct?
To make it more challenging, you say you have three tables involved, but I can only identify 2 for the fields involved: the layout's (work request), referente (for Ragione Sociale), and referente (for cognome).
Can you try to describe this more fully, perhaps showing the relationships involved? (tableOccurrenceName::FieldName = TableOccurrenceName::FieldName is a simple way to post relationships.)
If this is a conditional value list problem, have you seen this thread?
Custom Value List?
I believe I have worked it out. Yes it was a conditional value list. The conditional value list I was making out harder than it was. I think I was a little confused by trying to link three tables together. About the first part foreign keys, To make it easy I created a Calculation field with the last and first name. So when a person selects the business name then they go to the contact person it only lists the contacts connected to the business name. They see fk - lastname - firstname, very easy to find who they are looking for. Thank you for all your help!!