Hi,
I've spent hours on this one and I'm still getting it wrong. I'm working on a database for a consulting/training company. I have (for the sake of example) 2 tables. I have one table that lists the many company locations around the world and another table that contains basic program information.
Training Centers Program Info
CenterAuto ID# (primary) Program# (primary)
NameOfLocation BookingTrainingCenter
Address,Phone, etc. HostingTrainingCenter
TrainingLocationCenter
OtherProgramInfo
So, my problem is that I have 3 fields in the Program Info table that need to be related to the Training Centers table in different capacities. The training was booked by one center, hosted by another and took place at another. Do I need to create 3 separate tables of Training Centers (Hosting, Location and Booking)? I can't connect the Training Center ID with all three training center fields in the Program Info table. What should I do? HOPE THIS MAKES SENSE. Thanks a lot!
I've spent hours on this one and I'm still getting it wrong. I'm working on a database for a consulting/training company. I have (for the sake of example) 2 tables. I have one table that lists the many company locations around the world and another table that contains basic program information.
Training Centers Program Info
CenterAuto ID# (primary) Program# (primary)
NameOfLocation BookingTrainingCenter
Address,Phone, etc. HostingTrainingCenter
TrainingLocationCenter
OtherProgramInfo
So, my problem is that I have 3 fields in the Program Info table that need to be related to the Training Centers table in different capacities. The training was booked by one center, hosted by another and took place at another. Do I need to create 3 separate tables of Training Centers (Hosting, Location and Booking)? I can't connect the Training Center ID with all three training center fields in the Program Info table. What should I do? HOPE THIS MAKES SENSE. Thanks a lot!
