Auto fill in field 2 based on field 1

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

Guest

I am setting up a database, with users, computers and licenses. I have
created a table users, a table computers (In the computer-table there is a
look-up to the user-table), and now I want to setup the licenses table.

Since licences are installed on computers, I have a lookup to the
computer-table.
But for better understanding I want also the user listed in the licenses
table. I can add this to the look-up filed, but I want it always vissible in
tha table.

Can I add a field which is automaticly filled with the user, based on the
selected computer ?
 
panjo said:
I am setting up a database, with users, computers and licenses. I have
created a table users, a table computers (In the computer-table there
is a look-up to the user-table), and now I want to setup the licenses
table.

Since licences are installed on computers, I have a lookup to the
computer-table.
But for better understanding I want also the user listed in the
licenses table. I can add this to the look-up filed, but I want it
always vissible in tha table.

Can I add a field which is automaticly filled with the user, based on
the selected computer ?
Click to expand...

First you need to ask yourself if you want the user to change on your
records if the user changes computers.

If you want the user to changed if they change computers, you don't want
to store that data, but rather simply look it up anytime it needs to be
displayed.
 
Back
Top