Ok programming gurus and the likewise folks! I have a scenario for you that needs your attention, if you would not mind that is....
In the AlphaSports application, there is a "Customer Information" form, opening that in form view and selecting search by "Bill Country" or "Bill State Region" or "Bill City" or "First Name" or "Lastname" etc. etc...one sees that in the embedded browse field values are repeatedly shown. For example if the user selects: "Lastname" he will see two fields in the browse that have the values: "McDonald" appear twice, If he selects "First Name" he sees the values "James" appear more then once....and the case goes on....
I understand why this is happeneing, most prolly because the values that the browse is showing are all and every respective field value for all the records in the database that relate to customer information.
My question is: How to eliminate duplicate field values in this embedded browse scenario? For instance when i want to search by: "Bill City" i dont want to see multiple occurances of "Arlington" repeatedly show up in the browse--just having "Arlington" listed once in the browse would justify the needs of anyone who wants to search for Bill City=Arlington. Does anyone catch the drift of the cuisine i am trying to cook up!!?
Please let me know...much appreciated before-hand for taking your precious time to read this thread!
In the AlphaSports application, there is a "Customer Information" form, opening that in form view and selecting search by "Bill Country" or "Bill State Region" or "Bill City" or "First Name" or "Lastname" etc. etc...one sees that in the embedded browse field values are repeatedly shown. For example if the user selects: "Lastname" he will see two fields in the browse that have the values: "McDonald" appear twice, If he selects "First Name" he sees the values "James" appear more then once....and the case goes on....
I understand why this is happeneing, most prolly because the values that the browse is showing are all and every respective field value for all the records in the database that relate to customer information.
My question is: How to eliminate duplicate field values in this embedded browse scenario? For instance when i want to search by: "Bill City" i dont want to see multiple occurances of "Arlington" repeatedly show up in the browse--just having "Arlington" listed once in the browse would justify the needs of anyone who wants to search for Bill City=Arlington. Does anyone catch the drift of the cuisine i am trying to cook up!!?
Please let me know...much appreciated before-hand for taking your precious time to read this thread!
Comment