Linking variables from other db

R

ra

I want link two databases together by a common table - however I only want a
subset of the variables from the main database.

Database A has tblSubjects with 10 variables.
Database B needs to link to tblSubjects, but I only want to see 2 of the 10
variables.



How can this be done?
 
J

Joan Wild

Why don't you just link to the table and create a query in Database B that
shows only what you want?
 
R

ra

Database A has personal information in it and each person has a unique ID
number. Database B only needs that ID number and cannot have the personal
information in it.
 
J

Joan Wild

Two possibilities. Use

SELECT [ID number] FROM SomeTable IN 'C:\path to Database A\database A.mdb';

However if the users can't open Database A because it's secure, that won't
work for them.

You have a case for creating a separate table for the 'personal' information
vs. 'public' information - with a 1:1 relationship between the two tables.
Then Database B could create a link to the 'public' information table in
Database A.
 
R

ra

Thanks so much. I knew of option 2 but wasn't sure of the coding for option
1. I'll give it a try.



Joan Wild said:
Two possibilities. Use

SELECT [ID number] FROM SomeTable IN 'C:\path to Database A\database A.mdb';

However if the users can't open Database A because it's secure, that won't
work for them.

You have a case for creating a separate table for the 'personal' information
vs. 'public' information - with a 1:1 relationship between the two tables.
Then Database B could create a link to the 'public' information table in
Database A.


--
Joan Wild
Microsoft Access MVP
ra said:
Database A has personal information in it and each person has a unique ID
number. Database B only needs that ID number and cannot have the personal
information in it.
Click to expand...
Click to expand...
 
Top