I've got two seperate database files - a User database with each user and various info as individual records and a Software database with all of our software licenses.

Each user has a unique login name - Joe Smith would be jsmith - and in the User database record is a field for the software they are currently assigned called "SW Assigned". In my Software database, the records all have a unique ID number and have a field "Assigned to:" which is filled with a login name of the user that is assigned the software(ie., "jsmith".)

I'm trying to create a relationship that automatically fills the "SW Assigned" field in the User database when I enter the users login name to the "Assigned to:" field from the Software database. How can I do this(assuming that i can) and can it be done the other way around - if I enter the unique ID number of the software in the User record, have it autofill the software's "Assigned to:" field?

Thanks!

check the evaluate function wich reacts by changing a certain field content... there you can place a string which can be pasted in a certain field on any other related table...

WL