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