Microsoft Access...need help

[RightHandMan]

I have 2 Seperate Databases, with Identical columns...
The data they have in common is the CustomerID #. One DB Has just customer Names and ID# the other has ID# and Order# / Date. I want to combine the two databases and all info so i end up with 1 database With ID#, NAME, ORDER#, and DATE. I dont want duplicate entries. How can i accomplish this???

[EscortBiz]

just do a query

[RightHandMan]

on two seperate databases?

[King Porn]

relational database

[King Porn]

Or if you really, really don't want two tables, create a script to read in both tables sorted by CustomerID and write all fields to a new table.

[Overscore]

There isn't any built-in way to setup constraints between two separate Access databases. Why do you have two, if they're both storing the same data?

[RightHandMan]

they both arent storing the same data...they are storing relative data. one has id# and name....the other has id# and invoice#

[Overscore]

Originally posted by RightHandMan
they both arent storing the same data...they are storing relative data. one has id# and name....the other has id# and invoice#

You'll want to keep all the data in one database then, to keep it relational.

[RightHandMan]

Originally posted by Overscore
You'll want to keep all the data in one database then, to keep it relational.

thats what im trying to do...but i dont want a relational database, i want one DB

[Overscore]

Originally posted by RightHandMan
thats what im trying to do...but i dont want a relational database, i want one DB

You do want a relational database. A non-relational database serves little purpose if any... Don't worry about the "relational" terminology for now - just get your data into one database and you can worry about semantics afterwords.

[Overscore]

BTW, where is this Access database? Are you using it on a site? Is your site hosted on a Windows box? Or are you using Chilisoft or something?