Not all of that appears in your screen shot, but assume that you have:
But I'm not absolutely sure what you mean by this:
I want to go to my Work Order Table and create a new work order based on the Account Name -> Contract -> Shoot Type -> Job.
In what field are you entering/selecting data that will use the conditional value list?
Do you want to select an account and get a value list of only the Jobs for that account? Do you want to set up a hierarchical value list where you select an account, select a contract from a list of contracts for that account, then select a shoot type from those for that contract, etc?
*Sorry I thought I had posted in the wrong area previously.
Thank you for the quick response. Sorry for the lack of clarity of my previous post. However, yes I was looking to create a hierachical value list that I can select from. Attached is a sample of a screen where I am trying to use this list.
Essentially upon the creation of a new record a Work Order number would be generated (simple serial Number) The user would select the account then the contract, shoot Type, and Job form the value lists. They are all based off of primary and foreign keys to relate up through the database.
I have other occurrences where I would like to use these Hierarchical Value lists as well, so I am trying to not only implement it in this situation, but also understand it better so I can reuse it in other areas. However, if there are better ways to do some of these things I am all for that as well.
Thank you again for your help with this matter.
Ok so I recently was able to get a filemaker consultant from RCC to help me out with this and some other issues I was having. I am posting the results of my findings and new structure.
What I learned is that it is impossible or extremely difficult to have conditional value lists spanning multiple tables, however, you can set up a table to do just that for you with the use of multiple foreign keys. For example I had to add the foreign keys of AcctID and ContractID to my jobs table to make it work properly. I originally had thought this might pose a problem, but so far it makes it easier to enter the data and a way to track things a little easier.
Phil Thank you again for your help and response. I appreciate the support.