sahons

Indeed, this is a much more elegant solution! I will have a look at it. It means some major reorganization because right now all the information with restricted access (which includes a lot more than just the owner) is in that separate file. Apart from the problem with access privileges, I was trying to avoid separate layouts... Using access privileges with calculations would mean that I could have it all in one file. I'll give it a try :P

Thank you Razumovsky for your suggestion. If I understand you correctly, with your solution, the records in the two files are only related if the owner is public. If the owner is private on the other hand, there is no relation. But as the people at the estate who have access to all the information anyway, also to the password protected "artist_owners" file, need this connection between painting information and owner information, this is no option for me. The privacy issue only comes up with guest looking at the database.

Oh, saw your change! Thank you very much, now it works!

Thank you for your quick reply! I've tried your solution and it works fine with those entries that are private. The last name field in the "artist_main" field now shows 'private'. But the public entries only show a question mark in the same field. ?

Hello everyone! I am working on a database for an artist's estate containing information about all of his artwork. There are two related files. Lets call them "artist_main" and "artist_owners". In "artist_owners" information about the artwork's current owner, like name, address etc., is stored. As there are owners who do not wish to appear in any listing or publication, I have a field called "owner privacy" that has two options to choose from: public or private (value list, radio button set). In the future, art historians will come to the estate to look at the database. They will only be allowed to look at the "artist_main" file. What I am trying to do now is to have a layout in my "artist_main" file showing the owner's data - but only if "public" is chosen in "artist_owners". I've tried to do an IF calculation for the individual fields (in this case last name) If ( provenance::owner privacy = "public" ;owner last name = provenance::owner last name ; "private" ) But unfortunately, this doesn't work... Has anyone a suggestion? Thanks!

I have a layout for printing that combines all the information from other layouts. It spans two pages in layout mode. As the fields' information content varies, I use sliding. In preview mode/printing the follwing happens: All the fields that are slided to the first page show up properly but the text labels belonging to them do not. They just disappear. Turning off sliding or turning the text labels into fields is the only way to get them to show. The second problem I have with sliding: When slided to the first page certain fields get separated (one part of information showing on page 1 and the other part on page 2). This wouldn't be such a big problem if they were just plain text fields, but check box fields are affected, too (and they sometimes get separated in the middle of a check box).

I have solved the problem! There is a "Search" button in each of my different layouts. Before, I only used it to go to "find mode". I've changed that now, specifying a simple script (see attached picture) for it - and it works just fine. Thanks!

You are right, it works like that. The problem remains though. It only works if I go to 'find mode' and manually activate the adjusted find script. I just realized that I must be looking at the wrong script. When using find mode there seems to be another script. As there is no other find script in Script Maker, I assume that the one being used is a hidden one (?). I could add a search button in my layout that would use this find script. But I would like to avoid that, if possible. Which script is being activated when pressing enter in 'find mode' or using the find button in the status area?

Translating was easier than I expected, just had to change the user interface language. I've added a screenshot of the search script I'm using.

Thank you for replying. I have no problem sorting the data manually after performing a search. I've tried to add the sort function to my search script (at every possible position) but it still doesn't work. Is there maybe an additional step I have to add in order to make it work? I start translating the script, maybe that will help.

Hello all I have a database (FM 7, PC) with art objects and I would like to adjust my search function so that it sorts the data (using a unique code) after finding it. Right now, it shows all the found data in no apparent order and I have to use a sort script afterwards. As others will use the database as well (who might even know less about FM than I do), it would be much more convenient if the sorting was integrated in the search script. I've tried to add the sort function to my search script but it didn't work so far. Can anyone help me with this? P.S. I'm not posting the search script as it is in German, but if anyone needs it in order to help me, I will translate it.