Link two tables from Access database to Admin. database 1

[hollyann]

I have two databases that two different people are entering data into. One database for adult clients and one for child clients. The third database is the Admin. database where all data from the other two databases needs to be imported into for billing. I have created the links in the Admin. database but I can't figure out how to bring the data into one table into the new database.

 

[Guest_imported]

If you send me an email with your tables' structure I might be able to give you some better guidance. You need to be able to join fields or establish some relationship between the fields but i need more info like field names etc to suggest anything further.

 

[Guest_imported]

Sorry here's my email address

chucky@bettanet.net.au

 

[Rohdem]

Are the tables in the 'adult' database and the 'child' database the same?? If so, might I suggest having a 'back end' database that the 'adult' front end and 'child' front end link to.

If the tables are not the same, then use append/update queries to merge the two tables together into a new table.

Mike Rohde
rohdem@marshallengines.com

 

[hollyann]

The tables are exactly the same. If I create a "back end" database will it allow me to add additional tables unrelated to the other two (employee info. etc)? The Admin. database is necessary to bring all clients together because it needs to then link to the billing database. The structure of the databases contain the following fields:

Autonumber (primary key)
First Name
Last Name
Address (etc.)
Phone
Program Objective
Diagnosis
Caseworker
SS#
Primary Source of Income
Monthly Income
Medicaid Number
Work/School Status
Class Member (Yes\No)
Male\Female
Psychiatrist
Medication

 

[Rohdem]

You can put whatever tables you want in the back end, and then develop front ends to allow the users to show/enter only the information that you want them to see. You could have an adult interface, a child interface, and a adminstrative interface. You can split these interfaces into three different databases or combine them into one and use Access security features to control who can use what interface.

Mike Rohde
rohdem@marshallengines.com