Filter on a field from an unrellated table

[zagzebski]

I have a field "Salesperson" that I want to filter on.

I also have a concatenate field in another table that has multiple sales people in it.

Table 1

SalesPerson

John

Lisa

Table 2

SalesPerson Concat         Members

Sam|John|Brian                         50

I need to add an expression so that when the user selects the SalesPerson it will search the "SalesPerson Concat" field to see if the  value is contained in that selection.

For example:  if the user selects John then it would retrieve the 50 members, but if the user selects Lisa then it would NOT retrieve any members because Lisa is not contained in the SalesPerson Concat field.

Note: my problem is there is no relationship between these two tables.

Any help is appreciated

Zag

[MarcoWedel]

Hi,

although I agree that you should go for the link table, a front end solution however would be an OnSelect trigger on the SalesPerson field with a "Select in Field" action on the "SalesPerson Concat" field using a search string expression like:

=If(GetSelectedCount(SalesPerson),'(*'&Concat(SalesPerson,'*|*')&'*)')

hope this helps

regards

Marco