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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top