2 Replies Latest reply on Mar 26, 2012 1:12 AM by Lawlerdev

    Viewing records in related file that aren't visible in main file (server issue)


      Hi there,


      I have a strange problem that I would love some help on to resolve. I enclose a sample set of files to demonstrate this issue. However to test this problem the files need to be loaded onto Filemaker Server.


      What I want to do in the Reports file is to limit the viewing of the records to only those with the same cost centre code (CC Code). So only those logged in with CC code 1 can see records for CC code 1. I am using the global field G CC Code to set the cost centre in each case.


      In the Visits file I have a portal in which I wish to display all the records regardless of whether they belong to CC Code 1 or 2. I am acheiving this by limiting the security settings in the reports file as follows "CC Code = G User ID or Get ( LayoutName ) = "Visits""

      This all works fine until I move these files to a server and then only the records that are visible in the Reports file are visible in the Visits file.


      The master account name and password is "admin" and "admin" and the user password is "edit" and "edit"


      Any help gratefully received

        • 1. Re: Viewing records in related file that aren't visible in main file (server issue)

          What sticks out to me is that there is no corresponding "edit" privilege set and user in the Reports file.


          I'm not sure why you have these tables in separate files. If you wanted a separate file it may have been easier to have the second file as the "interface" file which only showed records by a relationship to visits which in turn related to reports. It is a bit hard to know without more info about the sort of interface you want to achieve.


          You could make the CC the account name and then have the CC auto-entered into the global CC field which then shows by relationship and security only the associated Reports. If the user then opens the reports table it only allows them to see the records where that global (or the Account name) matches... ie regardless of layout.


          What you have done make no sense to me... why is the visits table even necessary? All the data you need is in the Reports table. You just want to restrict it to where G CC Code = CC Code.


          - Lyndsay

          • 2. Re: Viewing records in related file that aren't visible in main file (server issue)

            Hi Lyndsay,


            Thanks for your response. I need to prevent users in CC 1 from viewing records in CC 2 in the reports file. However in the visits file, I want everyone, regardless of CC to view certain fields for ALL records in the reports file. In the 'real solution' there are 'edit' privilages in each file, so I don't think thats the problem.


            The real issue is that this WORKS when working on the main file but not on a client file when shared. In fact this can be tested using peer to peer as I've just discovered.