S
Simon Dowse
Hi,
I have a form with a load of person data in it. There is
also a link to another which will display extra
information on that person, which is done by a query that
matches the username for the record on the form to a
record in the new form.
The 2nd form displays codes dependant on what user rights
that person has. The user rights are grouped into 3 areas
and I have a table that lists the codes by area. Is there
anyway to have a query lookup a code and then return what
area it falls into? I want the 2nd form to say the code
(which it does) but also what area the code is from.
Any ideas? (Hope this is clear!)
I have a form with a load of person data in it. There is
also a link to another which will display extra
information on that person, which is done by a query that
matches the username for the record on the form to a
record in the new form.
The 2nd form displays codes dependant on what user rights
that person has. The user rights are grouped into 3 areas
and I have a table that lists the codes by area. Is there
anyway to have a query lookup a code and then return what
area it falls into? I want the 2nd form to say the code
(which it does) but also what area the code is from.
Any ideas? (Hope this is clear!)