Steve has given sound advice. In fact it appears from your description that
his method is exactly the way table 2 with the officer names was created.
There is probably a third table with just the names of the potential
officers. Table 1 and Table 3 are linked in a many to many relationship
using the type of form that Steve has suggested and putting the resulting
data into Table 2.
With datasheet view, you loose some of the functionality of the subform but
gain ease of use. If you wish to add fancy event procedures to your
subform, you could create it as a continuous form but make it only as high
as a single row of fields, thus giving the save look as a datasheet.
Good luck.
Mike Buraczewski
[log in to unmask]
-----Original Message-----
From: Moskowitz, Steve E. <[log in to unmask]>
Date: Monday, July 05, 1999 2:06 PM
Subject: Re: [PCSOFT] MS Access Database Problem
>Matthew - The best way to do this is to create a sub-form to display the
>varying list of officers within the main form for the company.
>
>To do this, create a form based on the data you wish to display from the
>officer table. Format this form as a datasheet so all you see is the field
>names header and a row for each officer.
PCSOFT's List Owner's:
Bob Wright<[log in to unmask]>
Drew Dunn<[log in to unmask]>
|