I'm very new to access so please be gentle with me...
i want to present my users with a form to enter data (their meetings for a day) into my main table and by the side of it a list of the current meetings for that day to help them make their choices.
The main table is a list of all meetings every year so i only want to see the records for the day they are adding meetings to and only some of the fields (where/when/how long/who with/subject.
Ideally I'd also like to put a similar list by the side of it showing that day's appointments for the person they are meeting.
I know this sounds like a job for outlook but there are very good reasons why i can't use it including the need for a lot of related data crunching and the need to print reports in a very specific format.
One big question I have is does it have to be a continuous list or could i display them in a timetable format with the hours down the left hand side?
I'm not quite sure of the best approach...
i want to present my users with a form to enter data (their meetings for a day) into my main table and by the side of it a list of the current meetings for that day to help them make their choices.
The main table is a list of all meetings every year so i only want to see the records for the day they are adding meetings to and only some of the fields (where/when/how long/who with/subject.
Ideally I'd also like to put a similar list by the side of it showing that day's appointments for the person they are meeting.
I know this sounds like a job for outlook but there are very good reasons why i can't use it including the need for a lot of related data crunching and the need to print reports in a very specific format.
One big question I have is does it have to be a continuous list or could i display them in a timetable format with the hours down the left hand side?
I'm not quite sure of the best approach...