Unanswered: Design question for table to capture multiple dates
I'm attempting to design & write an Access database for an organisation I'm involved with - I'm a software engineer by profession, but weak on databases.
The requirement is this: I wish to capture availability information for specific people. Everybody within the organisation receives an availability sheet each month and nominates which days they are available. I want to be able to capture it as follows:
Person A is available on 11/07, 12/07 and 14/08
Person B is available on 11/07, 12/07, 14/07 and 13/08
The "people" will be stored on a separate table, so a key field will be used to reference to them. I'm stumped on how to efficiently capture the date information, in such a way that I can then extract who's available on what date.
I'd appreciate any & all assistance and suggestions on this, as it's causing me a bit of a headache.