Hello, I know probalby nothing about the access,
but I need a program, where I can SELECT the category, the city and the date, and it shows me the free people at the selected date.
So I started entering data to access like this:
I created tables:
Groups - primary key is group name
Cities - primary key is city name
People - primary key, name of person, primary key of group they are in, primary key of city
Events - primary key, event name, date
Event_People - Primary Key, an event id and a person id.
Am I on the right way?
Also what do I need to do, to show, the free persons?
So far, what I was able to do, is only to show, what person is attending at what events...
It would be great, if I create some kind of form, that asks me the group(category), the city and asks me to select the date from the calendar,
and then, it would open up a new window with a list of who are free at the selected date, from the selected city and category.
Thank you!
