Hi

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

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.

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 ]

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...