So I'm in a weird predicament. I accidentally removed a Form from a Data Source and broke the form, I've readded the Form to the Data Source but the Field Lookup rules have been erased and I didn't make this Form and really need help getting it rebuilt and I'm hoping it won't be that difficult.
All that I need is this. There are two drop-downs that fill with info from a lookup, Name, and Address. The way this worked before when you picked a Name it would autoselect the correct Address from the lookup or vice versa. However, when this happens you'd be able to still use the drop-down to change your selection.
However, with what I've been able to recreate when you pick one it auto fills the other but it wipes the dropdown to only include the Name and a blank space.
So with this if they accidentally select the wrong Name or Address the entire form is ruined and they have to restart from scratch.
How can I set this up in a way that picking a Name or Address autofills the other but still lets users change their option should they need to?