Hi Guys,
Hopefully a simple question here. I looking to create a form that creates a contract for a particular client we deal with (grounds maintenance). In that form I'm looking to give the end user the option of selecting an existing billing address (for a property mgmt. company for example) to to enter a new one (which would then be added to tblBillingAddresses).
What I would like to have is a dropdown menu that automatically generates all the billing addresses we have (just company name, short address) so the end user can simply select the address as opposed to having to look up the auto number attached to it.
What would be better would be to be able to use have an independent lookup that classifies each billingaddress as MgmtCompany or SingleCompany, and have the aforementioed dropdown menu only generate those BillingAddresses that are infact Mgmt Companies.
How would you reccomend I go about doing this WITHOUT having to manually enter a new mgmt company to the dropdown menu each time we enter into business with such a company (I need a real-time search query based on the above criteria, in a dropdown menu within our contract From.)
Thanks a million
BG
Hopefully a simple question here. I looking to create a form that creates a contract for a particular client we deal with (grounds maintenance). In that form I'm looking to give the end user the option of selecting an existing billing address (for a property mgmt. company for example) to to enter a new one (which would then be added to tblBillingAddresses).
What I would like to have is a dropdown menu that automatically generates all the billing addresses we have (just company name, short address) so the end user can simply select the address as opposed to having to look up the auto number attached to it.
What would be better would be to be able to use have an independent lookup that classifies each billingaddress as MgmtCompany or SingleCompany, and have the aforementioed dropdown menu only generate those BillingAddresses that are infact Mgmt Companies.
How would you reccomend I go about doing this WITHOUT having to manually enter a new mgmt company to the dropdown menu each time we enter into business with such a company (I need a real-time search query based on the above criteria, in a dropdown menu within our contract From.)
Thanks a million
BG
