Colin, it doesn't make much sense. You talk about a Category (whatever you
mean by that). A category of what?
I suspect that you are mixing up proper Forms with subforms and those
Subdatasheets, so beloved of the Access templates which you can download
online. You have very little control with what happens when you are using
them - what you see is what you get.
What do you mean by a Table Header? What do you mean by 'each person's
file'?
Do you mean that you want a user to see only his name in the main form and
all available events in the subform?
If yes (and so long as you are using forms, rather than a tarted-up table),
then you can demand that a user types in his User Number (or whatever field
you have in your database to identify him) in the form that opens when the
database is opened. This form will open the real form, filtering this real
form so that only the user's data is shown.
You will need the structure which Dale suggested with TblPeopleEvents. This
table will need its own primary key, then PeopleId and EventID as Foreign
Key fields. In Table Design you will create a unique index for PeopleId and
EventID when combined (instructions available if needed) so that the same
event is never added more than once to the same person.
Since you want all people and events in your db, you will have an append
query containing the people table and the Event table, unlinked, to append
any missing combinations to your TblPeopleEvents (the index will prevent any
duplication)
I've pasted back the previous post with its reply in case anyone else can
figure out what you require
Evi
Thanks for that, however I'm not sure if that is exactly what I am
looking for.
I would like it to basically show a subform type thing on the screen
of each person's file with the list of events. That wouldjust show
the list with a checkboxes next to them. Also, when a category is
added, I would like it if that meeting could then be added as a table
header on a main events table that would have all the people's names
and within that colum a check box.
Does that make any sence?
Colin
Colin
Generally, this requires a third table (tbl_People_Events) which would
contain a field for the people and all of the events. You can do this one
of
two ways:
1. You can create that table, and populate it with every combination of
people and events, and add a Yes/No field (which would show up as a checkbox
on your form)to indicate whether they attended that event. The down side of
this is every time you add a person, you have to add all of the events to
the
table for that person, and every time you add an event, you have to add that
event for every person in you People table. When I do this, I generally
create a subform to display the events and the checkbox.
2. You can only store the People and the events they have attended. When I
use this method, I generally just display the list of events they have
attended in a listbox. Generally, when I use this method, I provide some
other method for the user to display the events that have not been attended,
so they can select from the list and add them for the user.
--
Don''t forget to rate the post if it was helpful!
Hi There
I am working on a database and have records for different people on
it. I want to have a table that shows a list of events that have or
will take place that will be easily editable for the administrator.
However I would like it that on each person's record it would show the
list of events and a check box next to the events that they have
attended.
Is there any way this can be done? I'm not a very experienced user of
access.
Cheers
Colin
