I'm using the new Access. I never created a relationship till now. I linked three databases. I expected to enable a right-click and launch and be able to see all the records in the linked databases. Nothing happened. What am I doing wrong.

Bob

PS Is there a way to review the code used to creat relationship. I'm from dBase 4 where we had a dot prompt or regedit, not graphics. Not a complaint. It might taker me abit.

When you say you linked three databases, what do you mean exactly? An Access database is a single file that contains many tables as well as queries, forms and reports. It is possible to link databases together but I'm just wondering if that is what you mean here?

Do you really mean you linked three tables (by creating some relationships)? Yes this is done graphically (and can also be done by code). But this only defines the relationship. It does not "join" tables. If you wish to see tables with identical structure "joined" then create a UNION query (think of it as joining your tables vertically). If you wish to see data from different tables where there is a relationship between the tables then create a JOIN query (think of it as joining you tables horizontally). This is standard theory for SQL based relational databases i.e. not specific to Access.

hth
Stopher

Been doing a little reading Access 2007 on Demand. I belive your right on what I'm doing. I see what you call a Database and a table. A different approch but good logic.

I'll check out the Union.

What I'm trying to do is link tables to use fields, rows, of information.

Example My master table "Permit" has only a bld, builder number. In order to find out the builders name I link to the "Builder" Table to the "Permit" Table to get his address, phone and name.

Bob

Example My master table "Permit" has only a bld, builder number. In order to find out the builders name I link to the "Builder" Table to the "Permit" Table to get his address, phone and name.Sounds like you need a join query to me. Take a look at the Northwind database (the example that comes with Access). You will see how tables and relationships are structured. Then have a look at some of the queries and see how they are made from one or more tables.

There's loads of stuff on the web about creating queries. Probably easier for you to search rather than me try to explain here.

hth
Stopher

But I got it to work. Thanks
Bob