Just woke up thinking about this and on reflection the jobs table may be an over complication and that job should be a column in the events table, assuming that there is no additional information you need to record relating to the job itself.
There’s...
If I’m following you correctly then it looks like you’ll also need a ‘Roles’ table which will consists of at least two fields, one lookup to events and the other to ‘Organizations’ - Then in that table add another column to the ‘Roles’ table of type...
Hi Joan,
From your explanation it seems like you just need a single table with your organisation info in it and another table for ‘Years’ (Or maybe ‘Events’ would be a better table name). The Events table will hold the information which is specific ...
