Form Suggestion

[kc1]

Morning / Afternoon / Evening

I am building a DB and I need advice regarding one part of it, a form.
The 'client' wants to see an 8 weekly work plan, Week 1 to Week 8 and they want to see it like a spreadsheet, i.e datasheet view.

All the data is held in 1 table, tbl_Master.



I suggested, having a page for each week, 1 to 8 with a subform in them.
However, it gets more tricky so the above option may not be the best.
In each page I need 2 subforms, as the data is at 2 levels, L6 and L5, L6 has many to one L5.

I am currently deleting / appending each week to 2 tables, tbl_Wk1_L5, tbl_wk1_L6 etc that sits behind the relevant subform in the relevant page.

i.e tbl_Wk1_L5 and tbl_Wk1_L6 in 2 separate subforms in page Wk1.

Is there an better way to create the 8 week plan, or is the way I have built it fine, i.e 16 tables that sit behind the main form, with 8 pages and 16 subforms.

Please ask any questions if this needs explaining further.

Thank

KC

[aytee111]

That sounds complicated! And it sounds as if you have it working already? Maybe you don't like your current design?

You can attach a copy of the database if you want to pursue this further, I can see if I have any bright ideas!

[kc1]

Thanks for the reply.

Yes, complicated is about right, but it does work. I just was not sure if there was a less complicated why to go about it.

For now I have reduced the number of forms and tables from 16 to 2 so I reckon this will be fine.

Thanks

KC

[dblife]

You say all the data is held in one table.
This suggests all the data has a one-to-one relationship.
Access is great for handling one-to-many and many-to-many relationships.
I think it would be useful to see your table structure? Just to make sure it is normalised?