I need a database formula to share data between two databases.

[Guest_imported]

I need a formula I would use to be able to retrieve data from one database field to another?
I'm am using Microsoft Works (2000) Database. I can retrieve information from one field & have it show results & do functions etc. in another field, within in one database, without any difficulty, ... but ....
I would like to be able to retrieve information from one database field to a whole other new database field.
Example: "Database #1" & "Database #2", I would like to know a formula to type into a field in "Database #2" that would retrieve information from a field from "Database #1".
I have no trouble figuring out how to move data within one database.(formulas, functions etc.) I have just ran out of available fields in "Database #1" & the only way I can think of to expand, to the space I need, is to exchange or retrieve data from a 2nd database or from Microsoft works spreadsheet.

 

[gigsvoo]

From what i understand, you should need a SQL statement to do this:

To retrive 2 different tables field values:

"SELECT a.field1, b.field2 FROM Table1 a, Table2 b WHERE a.field2 = b.field3" Thanks

Neo

http://communities.msn.com.my/VisualBasicwithNeo