Stupid Relationship Question

[ddreese]

I have a pretty dumb relationship question. On my layout so far I have a "casemanager id" field which is a 3-digit number, and a "Staff Name" dropdown that has a valuelist made from a calculated field that takes all the records in the staff database. The relationship that is set up so far is that the "casemanager id" is linked to the "staff id" in the staff database.

What will I have to do to make the "casemanager id" populate itself when I select something from the staff dropdown list? Also, I would like it to work in reverse. If they type in the number, the staff field should populate. Thanks guys!

[falkaholic]

Make it a lookup based on the casemanagerID -> staffID. Set it up in the auto enter in the field options dialog box.

Beware though, look ups only work once. Look around in these forums for more info on lookups.