Concatenating 2 fields from different tables and showing them?

Concatenating 2 fields from different tables and showing them?

Hi there

I have Contact Header (eg; Companies) and Contacts (people working at that company) = so far that is good.

I then want a Leads/Projects that is linked to Contacts. So ideally I'd like to be able to see a list of Contacts and Companies for the user to select from.

Example: (Contacts combined with Companies)

Abby (Internet Spotters)
Tony (Freds Emporium)
Will (Angus Traders)

So when the user creates a new Project then the user would auto-type/select from a drop down list of Contacts.

The reason for this is that we may be pricing a Project for Abby and Will - and their will be lots of Contacts an many Companies - so the drop down / multi select is great for that.

Just a case of combining the fields?

I played with bi-directional and so on. I also tried concatenating but thats what lead me to bi-directional because concatenation only works if the fields to be joined are in the same table.

Tricky one!

Any pointers welcomed.

Brynley