Hi Greg:
My form has three views; two of the views are to read data from a database.
I want my search criteria to base on dropdowns for example if the end user
pick a Country in the first dropdown control this limit the second dropdown
control to only states in that Country and when the user pick a state within
the second dropdown it limit the third dropdown to only cities within that
state and forth dropdown that is limited to only company or customer within
the selected city.
Then when the user clicks on the run query button it populate the master
table with the entire customer within the selected city. The master is link
to the first repeating table, making up of Address information ( here I need
to add some checkboxes with this table since a customer might have his
Contact, Billing and shipping address all differ and some customer might have
all three the same). The second repeating table contains the customer (First
name, middle, last name email, etc). So when the end user selects a
particular customer within the master table, all the addresses of that
particular customer is displace within the first repeating table giving him
the ability to use the checkbox to specify that customer contact address,
Bill address and shipping address and the contact person name and email from
the second repeating table. This information will be used to populate certain
fields with the third view. The same logic will be used in the second view to
select products.
Thanks very much for taking the time and hope to hear from you.
Kenneth.