Need some expert help please!!

I have a Tab Control on a form which contains a HEAP of information (contact details, addresses, finance information, email addresses, software information) for a 100 organisations (this number wont change) all in one table (67 fields x 100 records). A lot of this information would be better suited to having it in its own table (i.e. there are 5x6 fields for different contacts).

What I want to do is split this one table ointo a few different ones, basically one for each Tab Control. The only way I can seem to find of linking more than one table to the Tab Control is have the seperate tables and join them together with a select query (they all have the same unique Primary Key), though the problem with this is that the machines it has to run on are only PI-233 with 10MBp lan connection (the database is on a server) and it takes forever! The database is already over 2mb without any 'running' data (contants only).

Does anyone know a way of have more than one table as the recordsource for a tab control on a form without using a select query??

Thanks!!

Peter.M

Build a separate form for each tab page.

Thanks Pat for the suggestion. However i'd prefer not to do it that way, as there are already 8 other forms (excluding subforms)performing other functions and having each of these 6 tabs on this form as seperate form is going to get cumbersome especially when you need data from different tabs "at-hand".

If what i'm asking isn't possible then ok, it wouldn't be the first time Access couldn't do what I wanted, but I was hoping that there might be a way!!!! Oh well, maybe I can just hope that the company pulls their fingers out and gets better PC's!

Peter.M

There is no point in spliting the data into separate tables with one-to-one relationships only to rejoin them as the recordsource for the tab form. If the table contains "flattened" one-to-many relationships, they should absolutely be split out into their own tables.

Thanks for the reply. I thought of a way around my problem, if anyone was following. I will create a subform to place in the tab control.

Most of the data is indeed one-to-one so I will leave this in the main table.Where I really wanted to split the information is the "contacts" part where there could be between 1 and 6 contacts for that school. I have done this yet (just got to work!) but i'm going to create a table where you select the school, enter the contact type (headteacher etc) then the subform will filter the information for that school and list all relevant contacts. Might take a bit of fiddling, but I'll see if it works!

Here shows my lack of educated programming knowledge but what is a "'flattened' one-to-many" relationship?? I know what the others are! http://www.access-programmers.co.uk/ubb/smile.gif

Peter.M

(BTW: Is there any way to change my username. What was I thinking??)