Access 2000 front end, MS SQL backend
------------
Two tables (tblA and tblB) have a one-to-one relationship. tblB's primary key is an autonumber. Nulls are allowed on all fields of both tables except the primary keys.
I made a form whose recordsource is the following SQL statement:
SELECT...
Access 2000 front end, MS SQL backend
------------
Two tables (tblA and tblB) have a one-to-one relationship. tblB's primary key is an autonumber. Nulls are allowed on all fields of both tables except the primary keys.
I made a form whose recordsource is the following SQL statement...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.