Database Structure Question

[eluser]TerryT[/eluser]
There would be three separate people taking the minutes for the three meetings. The minutes would also include a field for who is responsible for the item, when they promised to complete it and when it was actually done. Therefore there is a need to be able to search on a meeting minute item to be able to update it.

If I change the numbers during the output, I wouldn't be able to run a query on them. And if the numbers are not sequential within each separate meeting, someone will ask, "How come #24 is missing? Was it deleted?".

I hate to do three separate tables for 3 sets of meetings since the fields are the same. Then what happens when there are 8 types of meetings? 8 tables?

Terry