Show almost all records from other file in value list

[koki142]

Hello,

I have two tables, one for publication types and other one where I want to

show all the publication types but no the "magazines" type.

For example, publication types:

ID Type

001 Magazine

002 Publication

003 Small Publication

004 Book

I want to show in one pop-up list all the types, but not the "Magazine", and

I don't know how !!

Thanks

Oskar

[LiveOak]

Don't use the display a value list from another file option. Instead display a value list based upon a relationship. Give all records in your publication type ID or Type (which I think you've done). Base the relationship upon a field (left side of the relationship) in which you create a multi-key. This field should be a global text field, if you set it up while off server and in single user mode. The field contains all the publication type ID's you wish to show in the value list separated by carriage returns. i.e.:

002

003

004

You can even make the value list dynamic by changing the contents of the text global field on the fly.

-bd

[koki142]

Thank you

Now the problem is solved, it works soooo pretty!!!