outofill

[Osyris]

hi all,,
please help.
in my company each user has an id to logon to windows ..
for example the user p093456 is Bill Gates !!
now i have a data base and i need to have two fields
the first one is called ID and the second User Name

what i want is when i enter a user id in the ID field automatically appear
the name of the user with this id in the User Name field..

can someone help me please..??

 

[Fred]

If taken literally, what you said conflicts with itself. If your whole
database is just one two field table (and presuming that you aren't entering
duplicates) then you would never enter an id (of someone whose name is
already in there) into a field because that record is already in the table.

- - - -

But let's say you want that to happen with a DIFFERENT table than your
name/number table. In that case link the two tables on the id field.
Then make a query that shows both tables. When you enter the number in
the id field of that differetn table, it should wark as you describe.