Microsoft Access...need help
 

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???

just do a query

on two seperate databases?

relational database

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.

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?

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.

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.

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?