Join 1 customer to its supplier

[Dinictus]

Hi,

I have a simple dbase which holds our clients. Now we want to register which supplier supplies a certain client.

So, I want to join multiple suppliers to 1 client like:

The hardware store:

supplier 1: (click here to find your supplier)
Supplier 2:
supplier 3:

The suppliers are als also present in the system the same way as the clients.

I use this feature a lot in other systems like Saratoga Avenue, here it's called a join field.

can Anyone help me out?

Thnks