structure help?

[Michael Knauf]

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?

[mr_vodka]

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.