Open record in another access db based on record in current access

[Guest]

Hi all,

I'm not sure if I can do this or not. I have two databases storing
different information but there is a common link between the two i.e.
RecordNumber.
Is there a way while I am in db One on RecordNumber(pk) to have a hyplerlink
on the form and open db Two, frmName, on the same RecordNumber?

Is this asking too much?

Thanks in advance,
Shawna

 

[Immanuel Sibero]

Hi Shawna,

No, it's not asking too much.
If you havent already, I would first read up on split database design:

http://www.granite.ab.ca/access/splitapp/index.htm

With the split database design, you can then link your Front End to multiple
Back End (i.e. in you case the multiple backends would be dbOne and dbTwo)
There are also many other advantages using the split database design.

HTH,
Immanuel Sibero