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 wrote:
> 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 ?

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.

--
Joseph Meehan

Dia duit