Assign multiple names to a single record

[JGrots]

Hello,



I have a Project Database where I keep track of projects throughout my plant. A project can have one owner or several owners working on it. Is there a way to assign multiple owners to a project?
I tried doing a subform but I don't like how it looks on the form and when I try to do a query that filters based on a person's name, the form has to be a single form rather than a continuous form which is not what I want.

Is there another way that I can accomplish this?

Thank you!

[June7]

Options:

1. multi-value field - not recommended, especially if you want to search and filter forms on the owner info

2. multiple like fields - another non-normalized structure that makes search/filter tricky but can be handled

2. a related child table of owner records

It is possible to filter/search a form set as continuous or datasheet view. I do this.