graemespence1
New member
- Local time
- Today, 12:48
- Joined
- Aug 15, 2012
- Messages
- 3
Hi i need help in the basic design of a database which I will outline above
The database is to record user numbers for activities that the centre runs and i need to record user numbers not only for activites that run once a month but also weekly. The main problem is that I need to be able to add and remove activities at the monute I have a monthly activities table which records the month and year and each of the monthly activities and a weekly table linked to the monthly table by the Month/year field
Month
(Primary Key) Month/year (Date field)
Activity 1 (Number)
Activity 2 (Number)
Week
(Primary key) Week commencing (Date field)
(Foreign Key) Month/year (Date Field)
Activity 1 (Number)
Activity 2 (Number)
The problem with my current design is that if i want to add or remove a activity i not only need to change the table fields but also redesign the forms and also the queries which I use to generate the reports and this adds a lot of time as the queries I use are linked to other queries I have to often edit a lot of queries and check that everything works afterwards.
What i'm wanting is any ideas to see if I can have it so that activities can be easily edited and added and removed.
Any help would be grateful and if you need extra info I will be happy to provide more.
The database is to record user numbers for activities that the centre runs and i need to record user numbers not only for activites that run once a month but also weekly. The main problem is that I need to be able to add and remove activities at the monute I have a monthly activities table which records the month and year and each of the monthly activities and a weekly table linked to the monthly table by the Month/year field
Month
(Primary Key) Month/year (Date field)
Activity 1 (Number)
Activity 2 (Number)
Week
(Primary key) Week commencing (Date field)
(Foreign Key) Month/year (Date Field)
Activity 1 (Number)
Activity 2 (Number)
The problem with my current design is that if i want to add or remove a activity i not only need to change the table fields but also redesign the forms and also the queries which I use to generate the reports and this adds a lot of time as the queries I use are linked to other queries I have to often edit a lot of queries and check that everything works afterwards.
What i'm wanting is any ideas to see if I can have it so that activities can be easily edited and added and removed.
Any help would be grateful and if you need extra info I will be happy to provide more.