I have a form that lists hospitals during a disaster. I have the table populated with name, address, phone etc. I want to be able to just select the hospital name and automatically populate the other fields in the record from the table.
Hospitals
Hospital Hospital address Hospital Phone Helipad(yes-no) Burn (yes-no)
The first three are now set as combo boxes that show the data but I have to find the match, The last two are yes no