>
> Dave-
>
> First, it sounds like you have a design problem. Your
tblPersonDepartment
> table should look like:
>
> DepartmentID, PersonID, PersonPosition (Boss, Secretary, Worker)
>
> This allows you to have 0-n people in each department.
Thanks, John.
Looks like design was the real problem. I suppose I could even put
positions into a third table to save a little space.
Dave
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
