Updating App - Suggestions on table/form design best practice?

Mark, thanks for the response.

Yes, there are 8 slots in the Work order, each one is identified as representing one of the 8 different contact types.

I first select my client, then I can click the dropdown which represents the VP, and it will only show me contacts from that client that have a contact type of VP. The same goes for the other 7 contact types, only showing me those specific contacts that are of that type and for that client.

As far as sending emails, I am not too concerned about that issue as the contacts themselves would not be receiving any emails.

Although I do like the simplicity which the brute force way of doing it allots me ... any pros to doing a m:m vs. this brute force method?

Thanks again!

------------------------------
Andrew
------------------------------