List by using a subform


A

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?
 
Ad

Advertisements

S

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.
 
Ad

Advertisements

A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top