Jump to content

ShamanTonberry

Newbies
  • Content Count

    5
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ShamanTonberry

  • Rank
    newbie

FileMaker Experience

  • Skill Level
    Beginner
  • FM Application
    15 Client

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Windows 8.1
  1. Hello everyone, As I am still relatively new to FileMaker, especially, scripts, I would like to ask for your help. I am currently in the process of preparing a historical database of officials delegated to maintain order in private estates. The existence of both the officials and the estates needs to be confirmed by historical sources. So the 3 tables are: Sources, Jito (the officials) and Jito-shiki (the jurisdictions in estates). One source can mention multiple officials and estates; an official may appear in many sources and hold jurisdiction in numerous estates; lastly, a given estate may appear in multiple sources and may have been under the jurisdiction of numerous officials during that time period. While I initially tried a many-to-many-to-many approach, it turned out too clunky and I settled for using a single table (labelled 'Joint' for the time being) that would record all instances a source mentioned a jito in relation to a jito-shiki. You can find the relationship graph below. In order to avoid creating numerous half-empty records, I limited the possibility of adding records to the Source layout only (since every official and jurisdiction need to be validated by sources) and designed an "Add record" button with the following script (mainly for reference): Set Variable [ $$Source_id; Value:Sources::Source_id ] Go to Layout [ “Joint” (Joint) ] New Record/Request Set Field [ Joint::Source_id; $$Source_id ] Go to Layout [ “Jito_Individual” (Jito) ] New Record/Request Set Variable [ $$Jito_id; Value:Jito::Jito_id ] Go to Layout [ “Joint” (Joint) ] Set Field [ Joint::Jito_id; $$Jito_id ] Go to Layout [ “Jito_shiki_Individual” (Jito_shiki) ] New Record/Request Set Variable [ $$Jito_shiki_id; Value:Jito_shiki::Jito_shiki_id ] Go to Layout [ “Joint” (Joint) ] Set Field [ Joint::Jito_shiki_id; $$Jito_shiki_id ] Go to Layout [ original layout ] For each record added this way, I type in the Source details in the Source layout and the basic information about Jito and Jito-shiki in the portal tool. Now here is the main issue - every once in a while the source will mention Jito and Jito-shiki I already have in the database. If that happens, I would like to be able to 'merge' those records (I'm thinking changing, say, the Jito_id in the new Joint record and deleting the resulting ghost record from the Jito table). The way I approached was: 1) Setting up a Script Trigger on Validation in the field that would inform me, if the name I have typed in is already figured in the database. I tried to use different search functions and criteria, but never got the desired result - i.e., a list of all the officials/estates that would have the same name, excluding the one I've just typed in. 2) In search results, add a button to every record that would 'merge' those records - I tried along the lines of overwriting the newly added record's ID in the Joint table to that of the record I want to merge it with, followed by deleting the now unnecessary ghost record in its original layout. I tired to base it on establishing variables, but the resulting mess always seemed to fall apart. Would you happen to have any suggestions/ideas on how I could approach this issue in a way that would make it, well work? Thank you in advance for your input.
  2. Hello everyone, I once again find myself asking for your help, since I am fairly new to FileMaker and don't know where to start. As I mentioned before (for those who haven't seen my previous question), I am currently in the process of preparing a historical database of officials delegated to supervise order in private estates. The existence of both the officials and the estates needs to be confirmed by historical sources. So the 3 tables are: Sources, Jito (the officials) and Jito-shiki (the jurisdictions in estates). One source can mention multiple officials and estates; an official may appear in many sources and hold jurisdiction in numerous estates; lastly, a given estate may appear in multiple sources and may have been under the jurisdiction of numerous officials during that time period - this led me to conclude that this is a many-to-many-to-many relationship. Each record has a form view with its own fields as well as most essential information drawn from related tables via portal. I allowed for the creation of new records, so that I only need to type in the missing details in related tables and everything worked - so far, so good. Thanks to you I managed to solve my initial issue regarding adding multiple records via portals, but ran into a new one. Right now, when I try to add multiple officials (jito) and estates (jito-shiki) they show up properly on the source layout, but after checking the individual records for the officials, they all list the same, first estate; likewise in estates, they all show the same official - the first one I typed in. Is there any way to relate those two portals so that the officials and estates in each row are tied together? The relationship graph is below. Thank you in advance for your help.
  3. Thank you, that solved the issue! I messed with the size of the portals themselves and fields were sticking out of them
  4. I tried to upload the graph directly, but it wouldn't let me for some reason. And yes, I have 'Allow creation of records in this table via this relationship' enabled on all related tables.
  5. Hello everyone, I am fairly new to FileMaker and I have been trying to find a solution to my problem on all sorts of forums and in all forms of tutorials, but have been drawing a blank so far. Maybe you can help me. I am currently in the process of preparing a historical database of officials delegated to supervise order in private estates. The existence of both the officials and the estates needs to be confirmed by historical sources. So the 3 tables are: Sources, Jito (the officials) and Jito-shiki (the jurisdictions in estates). One source can mention multiple officials and estates; an official may appear in many sources and hold jurisdiction in numerous estates; lastly, a given estate may appear in multiple sources and may have been under the jurisdiction of numerous officials during that time period - this led me to conclude that this is a many-to-many-to-many relationship. Each record has a form view with its own fields as well as most essential information drawn from related tables via portal. I allowed for the creation of new records, so that I only need to type in the missing details in related tables and everything worked - so far, so good. The problem began when I wanted to add more related records via portal. For some reason it would only show one record and no new line would appear. I tried to create a button that would simply add another related record, but they wouldn't appear in the portal. Does anyone have any idea what I might be doing wrong? The relationship graph is available here: https://drive.google.com/open?id=1N_pGUcavM1eS5BegpQhKgUZVvITNr6cy
×
×
  • Create New...

Important Information

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