Conditional Value List
Good day all, I used the tutorial here: http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists to create a conditional value list. My list consists of sectors and industries. Based on the sector selected, a list of industries is offered. The tables are Sector & Industry. In the Industry layout, the conditional value list works flawlessly. However, I have several other layouts where I need this list setup to function. For instance, in my Company layout, I need this conditional value list to establish what sector and industry and a company belongs to. However, it just is not working for me. I have tried creating new table occurrences that have a relationship to sector and/or industry field in the Company table in various fashions, but it just is not working.
I've seen where others have posed similar questions, but I just cannot crack it. Any and all help would be greatly appreciated! Thanks in advance!