M
Max
Currently working on a database that tracks meeting
minutes. This will probably be the first of many
questions on the subject. I have set up a single table.
There will be a series of minutes [Meeting No]. I may set
up another table witht the [Meeting No] [Meeting Date],
[Location] etc. What I want to do is have a data entry
form for each meeting. The tricky part is that there will
be meeting items that are carried over from previous
meetings. Example of meeting item: 01/06/04-S.001.1. I
broke this up into seperate fiels: [Meeting Date]"-
"[Subject Code]"."[Item No]"."[Item Sub No]. As meetings
take place Meeting items are addressed and new [Item Sub
No]s are added (01/06/04-S.001.2 and 01/06/04-S.001.3)
When the item is taken off the action list, I want to
remove it from the next meeting. I want to remove the
item from the next meeting, but I want to be able to go
back to past meetings and see all action items. I will
most likely be able to generate a report that includes
only the action items, but can I see only action items in
the Data Entry form. (Queries will be able to do this)
Main problem I face is how to maintain the history of each
meeting as changes are made to [Item No] (Basic solution
is creating a seperate field for each meeting. Put a
check by each meeting for each corresponding Meeting
Item. When item is unchecked that item is not associated
to the meeting.
Hope this isn't too much to go over or confusing. I
wanted to bring this up so I go in the right direction
when creating the tables.
Any help is much appreciated.
Max
minutes. This will probably be the first of many
questions on the subject. I have set up a single table.
There will be a series of minutes [Meeting No]. I may set
up another table witht the [Meeting No] [Meeting Date],
[Location] etc. What I want to do is have a data entry
form for each meeting. The tricky part is that there will
be meeting items that are carried over from previous
meetings. Example of meeting item: 01/06/04-S.001.1. I
broke this up into seperate fiels: [Meeting Date]"-
"[Subject Code]"."[Item No]"."[Item Sub No]. As meetings
take place Meeting items are addressed and new [Item Sub
No]s are added (01/06/04-S.001.2 and 01/06/04-S.001.3)
When the item is taken off the action list, I want to
remove it from the next meeting. I want to remove the
item from the next meeting, but I want to be able to go
back to past meetings and see all action items. I will
most likely be able to generate a report that includes
only the action items, but can I see only action items in
the Data Entry form. (Queries will be able to do this)
Main problem I face is how to maintain the history of each
meeting as changes are made to [Item No] (Basic solution
is creating a seperate field for each meeting. Put a
check by each meeting for each corresponding Meeting
Item. When item is unchecked that item is not associated
to the meeting.
Hope this isn't too much to go over or confusing. I
wanted to bring this up so I go in the right direction
when creating the tables.
Any help is much appreciated.
Max