Meeting Journal

[Lusitan]

Hello.

Don't know if this is the right place, but here we go:

I'm having trouble with this small db I've started to maintain record
of meetings. I have 3 tables (Participants, Meeting and a table wit
Participant_Id and Meeting_ID to join the previous 2)

Participants table:

Participant_Id - key, autonum
Participant_name - text

Meeting Table:

Meeting _Id - key, autonum
Subject - text
Date - date/time
Time - date/time
Place - text
Considerations - Memo
Decisions - Memo

I've built a form to register meetings and in that form I would like t
choose from the participants, wich took part of that specific meeting
either by checkboxes, multi selectio, whatever.
I'm not being able to do that. I can make the participants appear o
that form, but I can't select them in order for them to remai
"attached" to that meeting. Also, the table participants only has
records. It must not be allowed to add other participant.

How do I do that?

Also I have 2 queries (meeting by date and meeting by subject) tha
return blank.

I'll upload the db so that anyone can take a look at it and help m
find out what is happening. I've translated the tables and its content
to English. so I think that by doing so, the relations were deleted
But maybe it's better, so that anyone that looks at it won't b
influenced by my mistakes. The db is very small, only 120Kb zipped.


Thank you very much

 

[Lusitan]

Here it is

+----------------------------------------------------------------
| Attachment filename: meetings.zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=282443
+----------------------------------------------------------------