Permanent join on a table and a link

[AccessBEginner]

In Access 2000, I have a table (TableA) and a link to a SQL Server 2000 table through ODBC (TableB). Each has a unique ID column resulting in a one-to-one relationship. I would like to know if I can create a permanent join (not by running a query) so that if I open TableA, the data from TableB will appear as well. Note: I have done this through a relationship, but I that is not the route I want to go. Any help would be appreciated.

Thanks.

 

[LittleSmudge]

It sounds like you've come across one of the few good reasons for having one-to-one relationships between tables.

However, it's not clear to me what you are trying to do with it.

This problem normally arises when someone else has design control over the 'remote' table which cannot be changed - but you need data access ( read & write ) over both tables.
It's only really a challenge if you are entering New records or if the primary key values need to be changed.

To get to the data it is usual to present the fields as controls on a form. The form can be bound to the combined pair of tables using either a query stored in the database query window or in a query stored in the form's RecordSource property.

However, you seem to be suggesting that you don't want to do that - and I don't understand why not. Maybe if I understood your restriction then I'd be able to come up with an alternative.


G LS