Good Practise or NOT???? multiple tabs in a Form.. 1

[qb828]

Hi guys!!!

I am pretty new with Access database..
I am designing a data-entry form.
I have 8 categories and each categoires have 10 -15 fields/ sub-categories.
So I thought I use tabs in a form.
I know you can do it many different ways.
But just stick with this thought..

What I like to know is Do you consider a bad Practise if you use a way too many tabs in a single form?

Should I break them into several forms??
Thank you for your comments on this.



QB

 

[danvlas]

Multiple tab controls on a form is just fine. What's wrong is the table design: you should have one table with Categories and a second table with SubCategories related together.

If the SubCategories have the same attributes as the main categories, you could use the same table self joined on an additional field MainCategory (one-to-many relationship established between the primary key of the table and MainCategory).

Then you can use as many tab controls as you like.

I know you wanted to stick with your current design, but think of adding/removing a subcategory in the future: are you going to add/remove a tab/form/subform every time?

Do a search on Google for Database Normalization for more information on database design.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html