Hello,
I have created the combo box to select the customer lastname in my form, so that the rest of details of that customer appear. However the problem arises when 2 customers have the same lastname. Well I could use the record selectors to change between them but I would prefer rather the combo box to show the FULLNAME of the customer or to have a second combo box to select a first name of the customer ie: i use the 1st combo box to choose the lastname and then the 2nd combo box to select a first name of that customer.
For example:
Customer 1 firstname: A lastname: C
Customer 2 fisrtname: J lastname: U
Customer 3 firstname: B lastname: C
In my 1st combo box (lastname) I have chosen C. (there are two customers with this lastname)
In my 2nd combo box I can choose only: A or B .
Any suggestions how can I do it??
Thanks a lot!
Matt
I have created the combo box to select the customer lastname in my form, so that the rest of details of that customer appear. However the problem arises when 2 customers have the same lastname. Well I could use the record selectors to change between them but I would prefer rather the combo box to show the FULLNAME of the customer or to have a second combo box to select a first name of the customer ie: i use the 1st combo box to choose the lastname and then the 2nd combo box to select a first name of that customer.
For example:
Customer 1 firstname: A lastname: C
Customer 2 fisrtname: J lastname: U
Customer 3 firstname: B lastname: C
In my 1st combo box (lastname) I have chosen C. (there are two customers with this lastname)
In my 2nd combo box I can choose only: A or B .
Any suggestions how can I do it??
Thanks a lot!
Matt