Help with linking

July 11, 200322 yr

Newbies

hey all,

I'm trying to relate two databases. One is a contact list, and the other

collects information from 5 separate databases. So far I have created a

button in the contact db that opens the other db. Now I would like to have

a field in the "collection" db that shows selected fields from the contact

list db, namely the name and address fields. The way I would like it to

work is that when I click on the name and address field in the menu db, a

pull down or pop up menu appears with just the names in the contact list. I

would then select the name I want, and all the name and address fields for

that record in the contact list db show up in fields on the menu db. How do

I do this?

Thanks,

No12Be

July 11, 200322 yr

hi no12Be!

I think you sould post this in RELTIONS forum since it does not sound like u need any scripts....most people in here would assume that u want a scripted solution and might misslead you in the wrong direction....but it sounds like u need to relate 2 DBs and some "lookup" fields...perhaps a portal....anyhow. I would suggest the other forum with a different topic!

(perhaps read a few posts and look into Sample Forum for "Related Databases"...and/or post your topic: "Help with establishing a Reltionship".....this will lead u into defining fields-lookups- and perhaps portals.)

Good luck!