Value Lists and Lookup on Same Layout: How to Get to Work
Here is a problem I can't seem to resolve. On FM 10, I have related 2 tables. Table 1 has 3 fields: Yes/No, Site Name and State. Table 2 has 4 fields: Yes/No, Site Name, State and Rating. I have created a Conditional Value List in Table 2 to filter Site Name based on Yes/No and it works great. However, once the Site Name is filled in Table 2, I would also like Table to to Autofill State. Unfortunately, I can't seem to get this to work. If I deactivate the Conditional Value List and just include the Site Name -> State Autofill, that part works great. I just can't seem to get the Conditional Value List AND the Autofill to work together on the same layout. I think it has to do with the way the relationships are set up, but I'm drawing a blank. Any suggestions out there?