Auto Lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that I have created and I want to have one field auto
populated with information from another table based on two other fields in
the first table.

I.E. Table One - Super Office and Office would pull the Admin Code from
Table Two.

Can this be done? If so, how?
 
I have a table that I have created and I want to have one field auto
populated with information from another table based on two other fields in
the first table.

I.E. Table One - Super Office and Office would pull the Admin Code from
Table Two.

Can this be done? If so, how?
Click to expand...

It could, but it almost certainly *should not*. This field would be redundant.
You can just create a Query joining the two tables by the two fields and pick
up the admin code. Can you explain why you need to have a second copy of the
field in two tables (bear in mind that one instance could be edited so that it
IS WRONG with no easy way to detect that fact)?

John W. Vinson [MVP]
 
Not sure if I do need the information in both. I just want the person
entering data to be able to put the Super Office and Office and have the
Admin Code entered for them. Would be nice if they put the Super Office in
(only 6), then they would olny have a choice of the Offices under that Super
Office and finally have the Admin Code auto populated.
 
Back
Top