S
shaggles
I am trying to create a form that shows Employee info
along with company account info. Each account belongs to
a department and can have multiple authorized users and
some employees are authorized on more than one account. I
store this info in a table where the unique identifier is
a combination of employeeID and account number. I want
the form to show: EmployeeID, Account, All other signers
for that account, all other accounts for that employee.
Right now I have an employee subform (continuous) linked
to the main form by account number. It shows all reps for
that card including the current rep. How can I exclude
the current rep from the subform?
along with company account info. Each account belongs to
a department and can have multiple authorized users and
some employees are authorized on more than one account. I
store this info in a table where the unique identifier is
a combination of employeeID and account number. I want
the form to show: EmployeeID, Account, All other signers
for that account, all other accounts for that employee.
Right now I have an employee subform (continuous) linked
to the main form by account number. It shows all reps for
that card including the current rep. How can I exclude
the current rep from the subform?