N
Nolene
I have an Access database that has a tenant name, a property name and a
tenant number. On my infopath form I want to have two fields where a person
enters a tenant name and selects a property name which then looks up the data
in the Access db and displays the corresponding tenant number in a third
field (or displays an error message if the tenant name/number cannot be
found). If the tenant number cannot be found, the user should be allowed to
either manually complete the field or, to get fancy, be given a choice of
near matches to select from.
Oh and to complicate matters, the tenant number field will be disabled if
another field has the value of "New Lease."
What types of fields do I have to use to do this? If I try to use a text
field, I get a message that I have chosen a non-repeating field and that only
the first item will show. Will this take a lot of coding?
tenant number. On my infopath form I want to have two fields where a person
enters a tenant name and selects a property name which then looks up the data
in the Access db and displays the corresponding tenant number in a third
field (or displays an error message if the tenant name/number cannot be
found). If the tenant number cannot be found, the user should be allowed to
either manually complete the field or, to get fancy, be given a choice of
near matches to select from.
Oh and to complicate matters, the tenant number field will be disabled if
another field has the value of "New Lease."
What types of fields do I have to use to do this? If I try to use a text
field, I get a message that I have chosen a non-repeating field and that only
the first item will show. Will this take a lot of coding?