Selecting other list boxes using macros

[#1]

Hi

I am recently adding a company field to an existing application.

I have the company linked to a supplier and a customers table.

Because of the way the application currently works, I can't simple link both tables to the same company table without getting a circular join 'thingy'.

I know there is a way (using macros) that if the user selects the company field on the customer, it will also select the same company on the supplier table.  Its been a long time since I had to do this, and can't remember how its done.

Thanks

Andy

[#2]

Hi,

Try sth like that:

Action, Select in Field, Choose your Field (Company)

In the search string : = replace( '(' & concat($ DISTINCT Company, '|') &')', ' ', '?')

Fabrice