Developer Forum

I have a table that is linked to my GIS software, which is where I populate
all of the tables.

Is it possible to have multiple linked tables in one access project, and
then query against all of them as if they were one big table? All of the
fields in the tables are standardized, so every table could me merged.

I am just trying to figure out if I should have one table per customer, or
if I need to merge all of the tables together in GIS and just have one talbe
in Access.

Thanks!
Bryan

when you say

'access project' are you talking about an access data project?

i really love ADP ; i think that everyone should be using them.

now.. you need to tell us more about how many tables; you have; how
wide/tall they are; etc

you're giving us a symptom; but it's impossible for us to diagnose a
good route to go without knowing more like table count, record count;
etc

You *NOT* want to have one table per customer. Every time you have
a new customer you will need to create new queries, forms and reports
for the new customer. And what happens when you want to create
consolidated reports?

You are far better off having a customer table with a foreign key
being the customer ID in the child tables.

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.yqcomputer.com/