Hello!

I have a table Searchword that have Searchwords in Swedish and English (they posts are marked with "1" for Swedish and "2" for English) I whant to show only the Swedish Searchwords, how do I do that?

The word on Swedish and English have the same idnr so that I can change language easy so the idnr is no help..

I guess some kind of self join? I tryed with a global variable that held the language id I wanted to show but I couldnt make it work..

In SQL I would say: SELECT * FROM Searchword WERE LanguageID = "1"

Soooo simple but not in Filemaker??

Any tips?

Regards Jocke

To set this up in FileMaker, add a number field with global storage to the table you will be looking at the records from. Let's call this field gLanguageChoice.

Now define a relationship from this table to the Searchword table based on this field:

Interface <=> Searchword

Interface::gLanguageChoice = Searchword::LanguageID

Now when the gLanguageChoice field is populated with the right language code, the relationship can be used either to show a portal of Searchwords for that language, or a conditional value list.

Yeah thats fine, but if I want to show only the posts with LanguageID = 1 in an ordinary window?

So that a user can only see Swedish searchwords NOT the english ones... any ideas?

Regards Jocke