Are you aware of any sample applications that have the functionality I am seeking?

Thanks,

TFISHER

>Terry (via Marc),
>
>Marc has some excellent ideas. I'd expand that to include 2 tables: A 'parent' table which has information about the committee such as purpose, date started, etc. The second 'child' table would contain a list of ID's linking to the person table, as well as committee/person specific information like committee title, start/finish date, etc.
>
>HTH
>Barbara
>
>>Hi Terry,
>>
>>You might want to a add table "Membership" that relates the Persons to their Committee ... and add a field Title that would indicate if the person is a chairman, co-chairman or a simple member.
>>
>>For data entry you could create a rather straigtforward one to many form with the committe being the parent and the membership the child. Eventually you could join some (read only) person information to the child.
>>
>>The queries would consist of joining committees to memberships and persons to memberships to committees.
>>
>>
>>HTH,
>>
>>Marc
>>
>>
>>
>>
>>>Hello,
>>>
>>> I am in the process of writing an application in VFP6. I would like to use local views so that a modification to remote views will be relatively easy.
>>>
>>> I have one table that stores person information, i.e., name, address, dob, etc., etc. I have another table where I select people from the person table and assign them to a position. I would like to be able to open a data entry form, select people for various positions from the person table, then, at another time, be able to edit and query the information.
>>>
>>> As an example, consider a college environment where several thousand people are listed in a person table. At this college, there are many committees. A table is created to manage these committees. The committee table needs to be able to list a chairman, co-chairman, and several committee members as well as have several fields that record information about the particular committee. At times, it is necessary to change people on the committee, so you must bring up the committee form and edit it to change the people, as well as run queries on the committee and the activities it is performing.
>>>
>>> Can someone please provide me with guidance on the most efficient manner in which to proceed with this project?
>>>
>>>Thank-you,
>>>
>>>TFISHER