N
Nyla K
I'm developing a database that is being used by multiple departments. When
the database is launched, the end-users are required to enter their agent id
# in the login screen, which is unique to the department they are with. Here
is my problem:
Each dept has a unique set of fields that are based on their needs. For
example: Department A wants a comment field and Department B does not. In
addition, Dept B does not want to see the comment field that Dept A uses.
How can I please both departments without having to create two separate
forms? Is there a way to make the field visible based on the agent id# that
was entered in the login screen? If I have to create two separate forms, how
can I open the appropriate form based on the Agent ID#?
For example: Agent ID# = A1234 >> opens the Department A form. Or...
Agent ID# = A1234 >> unhides the comment field on a shared form.
Any assistance would be greatly appreciated.
Thanks,
Nyla
the database is launched, the end-users are required to enter their agent id
# in the login screen, which is unique to the department they are with. Here
is my problem:
Each dept has a unique set of fields that are based on their needs. For
example: Department A wants a comment field and Department B does not. In
addition, Dept B does not want to see the comment field that Dept A uses.
How can I please both departments without having to create two separate
forms? Is there a way to make the field visible based on the agent id# that
was entered in the login screen? If I have to create two separate forms, how
can I open the appropriate form based on the Agent ID#?
For example: Agent ID# = A1234 >> opens the Department A form. Or...
Agent ID# = A1234 >> unhides the comment field on a shared form.
Any assistance would be greatly appreciated.
Thanks,
Nyla