Relationship Issue...Please Help!! Can't figure it out

[MsPeppa]

I have a DB that is very complex. I have 3 tables. The first table only has "Date" in it (current date) the second table has "Shifts" (employee work shift (1, 2, 3 etc..) and my last table is "Extras" (includes Event, Appearance, First Name, Last etc...) The problem that I am running into is actually creating this relationship. For every "Date" there are Multiple shifts (as explained above) and for every Shift there are multiple "Events", "Appearances" pretty much for every Shift there are multiple employees working at that time. I have tried to make a one-to-many relationship from Date to Shift, then I made a one-to-many relationship from Shift to "Extras" but that did not work out well. Does anyone know how I can accomplish this..please!!

 

[franklin1232]

I think your first problem is your table setup. Why would you need a table with only the current date in it? That doesn't make any sense. The date can be entered automaticly in a number of ways. Creating a table that just keeps adding a record everyday probally isn't a good idea. Your extras table should be broken up. Employee information should have its own table, even if all you need is first and last name. You should have a table with all possible shifts. 1st 2nd 3rd, maybe swing shift. You also may need a table with all possible events. You then should have a table that puts it together. I'll call it Master. when a record needs to be entered you put the shiftID (all tables should have an ID field and key) EventID, EmployeeID, and auto enter the date() into the master table. This will give you a record with all information you need. This may not help you because I really don't know what you are tring to accomplish, but keep posting and I will do my best to understand.