Fetch Record: select from two different forms

Fetch Record: select from two different forms

I am creating a donor form.  I already have a member and a constituent form (two separate ones) -- they need to be separate.  I would like to use one ID code from the member / constitutent code to fetch a record from either form.


Here is an example:

MEMBER:  Student Jane, ID 33333

CONSTITUENT: Benefactor Organization, ID 22333

Member donates $50.

Constituent donates $100.


In the DONOR form: I want to fetch either Member or Constituent in one field and have their address record show up (just address, city, st, zip, etc) and the ability to add donor information that is now linked to that main record.


Thanks for any help.