List by using a subform

[ascagnel]

Hello all.

I have a single record for which I want to display a number of entries
for a field in a sub-form. For example, I have a table of
departments, and in the record for the IT department, I have a field
that should contain employees A, B, and C. On the form, I would like
to have a sub-form that lists name of employees A, B, and C.

Is there a better way to set this up, without resorting to "employee1,
employee2, employee3, ...", with individual fields for each employee?

 

[scubadiver]

Individual fields for employees. Sounds suspiciously like a spreadsheet.

One table for department (main form) and one table for employee (sub form):
one-to-many relationship.

 

[ascagnel]

I don't think I was specific enough... the employees are already in
their own table, but from the single record I can only reference one
of the employees, not a random range of them.