Linking a large database

W

wendywhuang

Hello Access Experts,

I'm trying to split some data (between Rural and Urban readings) into
seperate tabs (Orig all in Urban Tab). The requirements between Urban
and Rural is filtered differently, so I have to create diff Tables and
Forms for rural. I'm trying to copy the format of the Urban tab and
just eliminate and append approperiate data for the Rural tab. For the
Urban Tab, I have a filter where it sorts the data from Business Unit
--> District --> Plant # --> CP Area. I'm trying to do the same for
the Rural Tab, except to link Business Unit --> District --> Plant #
-- > Location Type --> Legal Description. How do I go about doing
this?

Also, I have no experience with VB. Thanks in advance for any help.
 
J

Jeff Boyce

You are describing a "how" (using tabs, filtering, formatting...).

Since everything starts with data in Access, start with describing the
underlying tables you are using.

By the way, you may not "have to create diff Tables" to have "Urban and
Rural ... filtered differently", but I can't tell because I don't understand
what you mean by these terms.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
T

Tony Toews [MVP]

I'm trying to split some data (between Rural and Urban readings) into
seperate tabs (Orig all in Urban Tab).
Click to expand...

You might be best having the data in one table but some records having
the rural fields filled out and the rest of the records having the
urban fields filled out. This might "waste" a bit of space in each
record but that's negligible compared to the extra work that you might
have to do elsewhere in your database.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
J

John W. Vinson

Hello Access Experts,

I'm trying to split some data (between Rural and Urban readings) into
seperate tabs (Orig all in Urban Tab). The requirements between Urban
and Rural is filtered differently, so I have to create diff Tables and
Forms for rural. I'm trying to copy the format of the Urban tab and
just eliminate and append approperiate data for the Rural tab. For the
Urban Tab, I have a filter where it sorts the data from Business Unit
--> District --> Plant # --> CP Area. I'm trying to do the same for
the Rural Tab, except to link Business Unit --> District --> Plant #
-- > Location Type --> Legal Description. How do I go about doing
this?

Also, I have no experience with VB. Thanks in advance for any help.
Click to expand...

First off...

Data is not stored in Tabs. Data is not stored in Forms. You can't copy data
from a Tab or from a Form into a table!

Get your table structures right *first*. You'll be able to run an Append
query, I'd presume, or maybe two of them, to migrate data from your current
unitatry table into a Rural table and an Urban table. Only then would you
start working on forms and filters!


John W. Vinson [MVP]
 
Top