Table fields with multiple occurences 1

[JustLJ]

Greetings,

I’m trying to achieve the following and don’t seem to find what I need in the on-line help nor here…

Need to collect, store and report on the following data:

Project number, Mtg-1 Date, Mtg-1-Attendee1, Mtg-1-Attendee2, Mtg-1-Attendee3, Mtg-1-Attendee4
(Up to 20 …)
Mtg-20 Date, Mtg-20-Attendee1, Mtg-20-Attendee2, Mtg-20-Attendee3, Mtg-20-Attendee4 (still the same project number, that won’t vary).

So, I was thinking I could set up a table which has Meeting Date occurring 20 times and Attendee1 occurring 20 times, etc… However, I don’t seem to be able to create a table with occurrences on the fields, nor do I find any help on that topic.

Anyone care to share how to have occurrences store on a table? I’m presuming in my coding I could refer to them by meeting_date(subscript), attendee1(subscript), etc. but I can’t seem to get far enough for loading the data.

Anyone?

Thanks!
LJ

 

[lespaul]

really should have a design more along the lines of:

Project
ProjectID (PK)
ProjectDescription
ProjectManager

Attendees (could come from already developed table : employees?)
AttendeeID
FirstName
LastName

Meetings
MeetingID (PK)
ProjectID (FK)
MeetingDate

MeetingAttendees
MeetingID (P-FK)
AttendeeID (P-FK)

this way each project can have many meetings and each meeting can have many attendees.

For more information check out Fundamentals of Relational Database Design


Leslie

 

[JustLJ]

Thanks Leslie,

Indeed all of that data (except the meeting dates/attendees) is in place and linked together. I just apparently went brain-dead in my rush not to think of a meeting table by itself. I guess I was trying to cram everything together, of course a no-no.

Thanks for the tip and your time to respond.

LJ