Refresh dependent ref field in a form, if parent ref field changes.

[Gustavo_Eduardo]

Hey guys,

I'm not sure if I'm just burnt out or what, but I can't seem to think straight. I've been trying to figure this out, and if any of you have experienced and solved this issue, I'd really appreciate your input.

The issue is that when I select ref-type records in a form (let's say there are two levels of nesting, like Country in the parent record and State in the child record), the child record doesn't clear if I change the parent record while filling out the form.

For example:

I choose the USA, then Miami, but then I want to choose Argentina right after that. I can do it, but the previously selected child record (Miami) is still there, and that's annoying. I think the ideal solution would be for it to refresh, but I don't know how to do it. Please, someone help me out. Thanks!

[Joseph_Seddik · Accepted solution]

Hello Gus,

Use the Valid if field of your child record to generate a list of valid options based on the option selected in the first record. 

[Joseph_Seddik · Accepted solution]

Hello Gus,

Use the Valid if field of your child record to generate a list of valid options based on the option selected in the first record. 

[Gustavo_Eduardo · Accepted solution]

Sorry for the delay. I did what you told me, Joseph. But instead of using the Valid If field, I used the Suggested Values field (I am more accustomed to it).

Once a value is selected from the parent list, the child list is displayed. If by mistake I want to go back to the parent list, of all the parent values, only the parent of the child list is visible. If I want to change it, I must first clear the child list, then all the parent values are enabled again. This is the logic I am using to prevent undesired fields from being filled in the database. Additionally, I use Valid If to prevent supplies from being filled if productions are being filled in the row, which also prevents undesired fields from being filled. Lastly, I use the Show If property to hide fields if the validity condition is not met. Again, thank you very much for your advice, my friend! Greetings from Argentina.