Hi
I am creating an employee db, with fields including employeeID, surname, firstname, partnerSurname, partnerFirstname, partnerID. As some partners work at the company, I want the partnerID to list (thorugh a value box) employeeID's that match surname to a partnerSurname and firstname to partnerFirstname.
Is this possible? Any help greatly appreciated.
Thanks in advance.

I think a recursive membership structure might suit you better in this instance.

Whereby you have

MemberID (Autonumber)
Forename (Text)
Surname (Text)
Employee (Yes/No)
PartnerID (Number)

In your relationships manager, you add two instances of the table, and join them on the MemberID and PartnerID fields.