Mutiple selection

[Lora]

I'm design a database where an employee (--officer) can
issue an asset to employee such as pager and cell phone
so that we can keep track if they return the item yet.
Since Office and Employee are on the same
database "Employees" If there are any way I can set up on
my from to select two different employees.

I have Employees tabel link to IssueAssets tabel.
Therefore, I could not select two different EmployeeID on
this form. Please advise.

Thank you,
Lora

 

[Dwayne Shrum]

I think you are wanting to self-join a table back to
itself so that one record can relate to another different
record in the same table. You do this by joining different
fields of a same table (i.e. supervisor field might relate
back to employee name field of the same table).