I have a field called CompanyName with the autofill property. (You will begin typing the name and it will be completed automatically)
In the same form, I have other fields such as company's address, phone number, etc.
This is what I need:
Once the CompanyName field is completed by autofill I need the rest of the information associate with this Company to be automatically filled out (ej address, phone number, etc) In cases when the company has a different branch, to be able to change the information with the new address ( I know this will create a new record like it would be a new company, but that's ok)
The DB basically will have clients and these clients will be receiving services from a particular company. Clients and company providing services will be linked, so I will have a form with all the clients information and then another form that will link the client with a particular company, this second form is the one I need to do the auto completion.
Thanks in advance for any suggestion.
In the same form, I have other fields such as company's address, phone number, etc.
This is what I need:
Once the CompanyName field is completed by autofill I need the rest of the information associate with this Company to be automatically filled out (ej address, phone number, etc) In cases when the company has a different branch, to be able to change the information with the new address ( I know this will create a new record like it would be a new company, but that's ok)
The DB basically will have clients and these clients will be receiving services from a particular company. Clients and company providing services will be linked, so I will have a form with all the clients information and then another form that will link the client with a particular company, this second form is the one I need to do the auto completion.
Thanks in advance for any suggestion.
