AnsweredAssumed Answered

Value Lists and Lookup on Same Layout: How to Get to Work

Question asked by steve4640_1 on Oct 19, 2009
Latest reply on Oct 19, 2009 by philmodjunk

Title

Value Lists and Lookup on Same Layout: How to Get to Work

Post

Hi Folks:

 

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?

 

Thanks!

 

Steve 

Outcomes