Using a link to another d/b as pop-up

[FionaMM]

Hi

How can I link to another database & show the contents of a field as a pop-up list & then select from it?

[falkaholic]

First define a relationship between the 2 dbs.

Then make a field in the database you want to have the pop up.

then go into the value list dialog box and define a new list, in the new dialog there should be a option to show contents of a field.

select the relation you just made and then the field you want to show up in the pop up.

now select the field you want to be a popup and go into "field format" and then set it to a pop-up for a valuelist for the value list you just made.

that should make sense but its hard to explain stuff, its monday morning.

[FionaMM]

Eric

You are a star.

It's easy when you know how!

Thanks for your prompt reply.

Fiona

[ March 05, 2002, 02:19 AM: Message edited by: FionaMM ]

[danjacoby]

Actually, if all you want is a popup list containing the contents of a field in another file, you don't need a relationship at all.

Not that I'm against relationships...