Design & layout

[Ani]

Design & layout-using tabs

Hi folks
I have 5 tables. These tables have been related but I will not know how well Ive done that until I set my forms up and enter data.
I want to design the user 'Forms' so that each table has a form but so that all 5 forms show at the same time as different tabbed pages. Just like the tabs on a web browser or at the top of this page.
ie the 5 tables have different information in them but are for one customer, so I need the 5 units of information to appear for every customer, in a tabbed page format.
Is that possible?
I hope I have explained that enough?
Thank you
Ani
PS From the 'help' on MS access itself I get the impression that I need to create a form with all 5 tables and then split the information up using the tab control? Im not sure that will work very well, I have a total of many fields in the tables?

 

[Uncle Gizmo]

Re: Design & layout-using tabs

I have a total of many fields in the tables?

As a general rule having a large number of fields in a single table hints at design problems.

If I understand your question correctly you have a customer table and four other tables. You want to have a tab control which displays the information from the four other tables for that particular customer.

If that's correct, then you want the main form which displays information relating to a single customer, and then held on this form a tab control with four tabs showing a form from the four related tables.

The other interpretation I have is that you want one form with five tabs on it, each tab showing information from a different customer?

 

[Ani]

Re: Design & layout-using tabs

As a general rule having a large number of fields in a single table hints at design problems.
I have:
15 fields in CustomerDetails tbl
16 Fields in HorseDetails tbl
8 Fields in Invoice tbl
16 Fields in PastureManagement tbl
8 Fields in Product tbl

If I understand your question correctly you have a customer table and four other tables. You want to have a tab control which displays the information from the four other tables for that particular customer.
Yes -
I have used
Primary key autonumber for CustomerDetailsID
PK autonumber for HorseDetailsID with CustomerDetailsID-number as foreign key
PK autonumber for InvoiceID with CustomerDetailsID -number as FK
PK HorseDetailsID-number for PastureManagement with CustomerDetails -number as FK
PK Product is text to Manually enter with CustomerDetails -number as FK

One customer may have many Horses
Each horse may have more than one Pasture mangment record
Each customer will have more than one invoice
Each customer may have more than one product
I think I have set the relationships correctly but dont know yet.

If that's correct, then you want the main form which displays information relating to a single customer, and then held on this form a tab control with four tabs showing a form from the four related tables.

Yes - I have tried using the form wizard but can only get two additional tables into the form as subforms.
I dont know how to do what you suggest above!
I have been looking at tutorials but am getting really confused. Help would be very much appreciated.
Cheers
Ani

 

[Uncle Gizmo]

I would suggest having a look at the last video in this series, excel-in-access-videos video five, it's not exactly what you want, however it will give you an idea of the endpoint you are aiming for . Once you have watched video five you may find that the other videos in the set makes sense. In other words I've suggested you look at the last video because if you started at the first one you would probably think why the hell should I be watching this!

 

[Ani]

Thank You! LOL
I will have a look and see what I can do then. I really like the idea of doing this little project myself but there are so many tutorials and different ways of setting things up it is quite overwhelming!
Im sure I will be asking questions again, I want my db to work. Thank you for your help.
Ani