Multiple databases on different locations in 1 big database

[Peter D]

I made a program with a database attached with my tables in it.
Different branches in the firm use that program. On the end of each
week they send me on a floppy disk that data (i know old-style, but
that's how the firm wants it). Is it possible to collect all that
data in one big database with different tables and still know from
what branch it came because some branches made the same input.

Anyone, anywhere, anyhow, anyway TX

[Michael Hopwood]

What you should do is give each branch a BranchID and import all info into
your existing tables (with added BranchID fields). That way you can link
the tables together using the BranchID field.

--
Michael Hopwood (Phobos)
"Peter D" <da*********@pandora.be> wrote in message
news:2f**************************@posting.google.c om...

I made a program with a database attached with my tables in it.
Different branches in the firm use that program. On the end of each
week they send me on a floppy disk that data (i know old-style, but
that's how the firm wants it). Is it possible to collect all that
data in one big database with different tables and still know from
what branch it came because some branches made the same input.

Anyone, anywhere, anyhow, anyway TX

[Peter D]

"Michael Hopwood" <la******@spammers.co.uk> wrote in message news:<Xd********************@brightview.com>...

What you should do is give each branch a BranchID and import all info into
your existing tables (with added BranchID fields). That way you can link
the tables together using the BranchID field.

--

Thanks Michael,
to be sure : so my table would have for example :

ID : autonumber
BranchID
Name
Product
......

Than i have to link those tables to my collective database and in a
query i collect :

BranchID
Name
Product
......
but not the ID because different branches can have the same ID for
different Products
I have 31 tables per branch and i have 6 branches. That means that in
my collective database i would have 186 imported tables. Isn't that
going to create some problems?