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

 

[Schlogg]

Use a third calculation field which doesn't contain the 'Magazine' category.
I think V5.5 might solve your problem more neatly; I haven't had a really good look yet.
Paul J. Cheers,
Paul J.