S
Sin
i have 2 tables with the 1st containing client's name and address, 2nd
containing client name, year of purchase and type of product. A form was
created with page 1 containing the client's name and address, on the 2nd
page, I want to creat 2 list boxes, the 1st list box value to be a list of
"year of purchase" that's applicable to that particular client with no
repeating years (as you scroll to different record on page 1, the drop down
list on page 2 will update itself with value applicable to that client), the
2nd list box value be conditioned to the client's name and value chose on the
1st list box, i.e. the values will be the list of product the client have
purchased for the particular year selected (distinct value only, the list
will filter out all repeatitive value). Is this achievable?
containing client name, year of purchase and type of product. A form was
created with page 1 containing the client's name and address, on the 2nd
page, I want to creat 2 list boxes, the 1st list box value to be a list of
"year of purchase" that's applicable to that particular client with no
repeating years (as you scroll to different record on page 1, the drop down
list on page 2 will update itself with value applicable to that client), the
2nd list box value be conditioned to the client's name and value chose on the
1st list box, i.e. the values will be the list of product the client have
purchased for the particular year selected (distinct value only, the list
will filter out all repeatitive value). Is this achievable?