Hi everyone,

I am an beginner on FM, so please be patient. I set up a database which works fine so far. Now I want to perform the following: Inside my main table I have fields for keywords. In my main layout which shows all data from one record, I want to have a list of other reords having the same keyword. The list should change upon entering a new or additional keyword. Preferably when I would click to one record in the list, it should be shown instead of the original record in the same layout.

I searched quite a while in the web but did not get a clue how to do that. I actually have no idea what the right search term would be. I hope that such a task is possible on beginner level.

Many thanks,

Stefan

Example for clarification: think of names and adresses. Show record 1 in a layout, while also showing a list of records with the same city as in record 1 with the possibility of choosing a record from the list to replace record 1.

a list of records with the same city

It doesn't seem to be the same thing as you describe:

I have fields for keywords.

Multiple fields? That is not a good starting point.

The adress thing was an example. From the keywords it differs only in the way that the keyword field might contain more than one keyword, while the city example does not. Does that makes things more complicated? The basic idea is to combine or relate records using keywords. Of course it would be the same than start a search each time for the keyword, but thats very unconvenient.

Thanks,

Stefan

If the keywords are separated by carriage returns, you can define a self-join (a relationship of a table to itself) as:

YourTable::Keywords = YourTable 2::Keywords

AND

YourTable::SerialID ≠ YourTable 2::SerialID

Then show a portal to YourTable 2 on the layout. This will show all other records that have at least one common keyword with the current record.

To go to one of these, put a button in the portal and set it to Go to Related Record.

Yes! It seems that "self-join" was the keyword to search for. I will try to figure that out for my database.

Many thanks!