April 30, 200718 yr I'm trying to create a database to handling scheduling of classes for a summer camp... So I have a table of Staff info, a table of class info, and a table of time periods... there are six periods, each staff member teaches a class each period, there are 20 classes and 30 staff... how do I relate the tables?
April 30, 200718 yr Make sure that each staff and each class has a unique ID. You would have a field in the time period table that stores the ID for each staff member and class.
Create an account or sign in to comment