Jump to content

Squeaky Data

  • Posts

  • Joined

  • Last visited

Squeaky Data's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Thanks, I just started to explore that and it looks like it should work. Do you know if this type of match has a name?
  2. I am not sure what to call this kind of comparison so I have had a hard time searching for any information. I have two list that are used to manage record access security. One list is generated for extended privileges and the other is from field data. List One: London New York List Two: New York Toronto London I am trying to figure out a boolean calculation to see if ANY of the values in list one match ANY of the values in list two. Pattern count will only work if the lists are in the correct order so I think I need to figure out a recursive calculation to compare each value individually from list one against list two.
  3. And that is the problem as they have a very broad definition of "affiliation" so it could mean that they are all members of a parent company or that they have the same owner or literally any other reason that they feel that they should be considered affiliated with one another. I was hoping there was some other approach than multiple joins but I think I will put a few in and ask that they try to identify master companies and associate the others to that rather than trying to trace through all of the possible paths. Thanks for the reply.
  4. Not sure what to call this type of relationship but I have companies that are affiliated with one another an they want to view all affiliated companies from any of the affiliated companies. So If: Company 1 is affiliated with Company 2 Company 1 is affiliated with Company 3 Company 3 is affiliated with Company 4 Company 4 is affiliated with Company 5 Then they should all be considered affiliated with one another and you should be able to see a list of companies 1 - 5 from any of the individual company records. I have sorted some of this out using a join table that joins to its self multiple times but there will always be a limit to how distant the relationship can be and still connect the affiliated companies. I have attached an example of the multiple joins. There are two layouts, one for companies and one for joins so you can see where the related companies link or do not link. Inserting more joins in the chain will increase the level of connectivity but I think there is always a limit. Wondering if anyone has a simple solution to show all the interconnected relationships other than just putting together a number of joins? Test_Self_Join_Many_2_Many.fp7.zip
  5. I already tried running the script with Full Access privileges but that didn't help. The script is running in an interface file and I am not sure that running the script with Full Access extends through to the Data file where the users field access restrictions are.
  6. I have a scripted import that imports between two tables in the same solution but we found that the import mapping changes for different privilege sets due to field access restrictions. We are finding that the data is going into the wrong fields because a user does not have access to certain fields in the source table even though those fields are not being imported. This makes a huge mess and inaccurate results. I would have thought that setting the import order in the script and using last order would keep the fields aligned correctly but that does not work even when running the script with full access privileges. I hope there is something simple that I have missed but this is a huge error if FileMaker remaps the import order because a users privileges do not allow them access to fields that they do not even need to import.
  7. I think I have found a less elegant solution by setting a global field to the extended privileges when logging in and then validating the access restrictions against that global rather than trying to validate it dynamically with the Get(currentextendedprivileges).
  8. I posted this to another list but am heading for a meeting and need to see if there are any solutions or options. I have a database built using the separation model with an interface and data file. They want to restrict users to only allow them to view records assigned to their region. So in the data file I set up a privilege set for each region and with an extended privilege that matches the region name set in the record. So the privilege set record access is configure to allow View when: PatternCount ( Get ( CurrentExtendedPrivileges ) ; Region ) >0 In theory this should work but seems to fail to restrict access when viewing the records through either the interface file or directly in the data file. Testing some other restrictions like only allowing them to view records they created seem to work but I need to allow access to other records for their region created by others. Any thoughts? Can FileMaker restrict record access based on Extended Privileges or do I need to figure out some what to restructure the database so that each region has their own table? Steve
  9. Would the record access if not empty lock out the ability to edit the entire record rather than just the single field?
  10. I have an auto enter field that is used to establish a relationship and trigger a number of lookups in other fields. The lookups work fine if the record is created in FileMaker but fails when the record is created using fxphp. The auto enter field is auto entered correctly when the fxphp record is created but the lookups are not triggered. Any ideas on why the different behavior and how to resolve it?
  11. I just found the combination. If the status bar is hidden and locked then the Go To Next record option and key commands are unavailable. Seems like a bug to me.
  12. I am trying to sort out what setting would not allow a user account to use the "Go To Record" options? If I log in with Full Access The Go To Record options are available under the Records Menu and Contral + Arrow Key options, but with any other privilege set they are grayed out even though it is the same Custom Menu Set. I even tried the standard menu set and all other privilege sets have no access to the Go To Record or key commands. I have checked that their Available Menu Commands is set to ALL in their Privilege Set so have just about run out of ideas. This is happening in FileMaker 11 on both Mac and Windows.
  13. I am seeing something similar when working in script debugger for long sessions and possibly when jumping between buttons quickly in certain situations. For example the other day I was trying to align fields for a scripted import with 2500 fields in the source column and when I quickly clicked from creation order to match names and back to creation order FileMaker froze and crashed. This in on Mac 10.5.8
  14. The new FileMaker 11 Snapshot Links look like a nice way to track a found set and could be stored in a container field for future reference but I would like to get more out of it. I am wondering if you could import the individual elements from the Snapshot file into separate FileMaker fields and later merge separate Snapshots to create a combined found set or new Snapshot Link? Playing with the Snapshot file in a text editor it looks like you could merge separate Snapshots by confirming that they used the same "baseTableID", updating the "rowCount" and combining the record numbers from each Snapshot Link. I am not very familiar with FileMaker XML imports and exports so I do not know if it is even feasible the import and separate the different attributes in the .fpsl Snapshot Link file and recombine and export them to a new .fpsl file.
  15. To update the filtered portal you need to trigger a script to (Refresh Window[Flush cached join results])
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.