Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Auraboros

  • Rank

Profile Information

  • Title
  • Industry
    Mental Health
  • Gender
  • Location
    Toronto, ON Canada

Contact Methods

  • Website URL

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks guys...I hope one day I have a handle on all this like all of you do. I have been taking courses but most of them do not get advanced enough. I love trying to figure this stuff out but I think there is some logic chip that is missing in my brain. I also make things too complicated. I got really close with this but I couldn't get my "script trigger on modify" to work correctly...it would snag and just sit there until I hit command-period. I think it is probably best just to have that yearly scheduled script run through all the records with the age field. Thank you both for the solut
  2. I set up a script trigger on the age field so when modified it inserts the current day in another off layout field. But now I don't know what to do with that date. How do I get the contents of the "Age" field to add a year when 365 days have passed from the modify date? I think I am going about this the wrong way... Thanks Comment! Todd
  3. Hi...I have looked high and low for this solution...maybe it is too simple for anyone to comment on! I have a number field...say I enter 50. In one year from the date I entered 50 in that field, I would like it to automatically increase by 1, to 51. I do not want to have to re-enter the number, and if I don't visit that record with the field in it for 3 years, then I want it to increase by 3. Increase by 1 each year. OK, let me tell you what it is. I enter the ages of clients' children, next to their names, in a database. I do NOT want to have to enter their birthdays, nor even
  4. I'm not sure why you say the T03aJT_JMC_musiclibrary cannot be the "one" and T03a_JMC_join_jmc|musiclibrary be the "many"...?? (I need to learn this stuff, I am just confused). T03a_JMC is a join table...joining another join table (T03_Join Music|Contacts (truncated to JMC). I am probably hopelessly confused... The way you set this up the first time does work. (see screen shot). I think I was confused that these tables needed foreign and parent keys...the music library table doesn't need a foreign key because it isn't a child to any parent table...the join table is always foreign keys bec
  5. Yes...the arrow in the portal now goes to the correct table and layout. The way you contend is correct still has the arrow going to the join table layout, which is not where I want it to go. I am not familiar with all of this enough to see the logic error. I AM trying to do something that may either be impossible to do, or the way I have attempted to do it faulty. Contact > Market Event | Contact Join Table > Market Event (many events to many contacts) I also want the Market Event Join Table to have this relationship: Market Event Join Table > Market Event | Music
  6. Wow...first of all, for some odd reason I sent a file that had the wrong relationship set up...which obviously didn't work...but the "right one" didn't work either... I have to ask...the relationship I tried to set up for the "Go to Related Record" was to get to the music library table (the TO) NOT to go to the Join table with a field put on the table from the music library table. Why is your way the only way to make it work, and in all of my other "Go to Related Record" arrows in other portals I go to the table itself that has the record I want...I know this doesn't make sense... L
  7. Yes, I did some work on it, still not solving my issue, I tried to delete files and it deleted everything...I am reuploading... **MusicalAmericaPRESUB copy.fmp12
  8. Hi...I have created a database using a "modified" anchor buoy method and so far everything works great...but...I have a portal in a "join table" that works fine...however, my button that is supposed to open the record in the portal row does not function...it returns nothing. The records are indeed related (see RG) as the fields show up from the related table without relational conflicts, but this button that is supposed to open the "library" table with the related record pulled up simply does nothing. I have attached the DB. Also a screen shot of the table where the portal is (it is actu
  9. Thanks...Sorry about the RG...I have been using different names (such as Contacts B for clarity in describing my situation, the RG is from the actual database.) Yes, this whole structure may be the cause for these difficulties...I originally wanted staff to be part of the orchestra table, but they are independent, move around, have all different information and often times get marketed to differently. It probably would not have been a problem to have staff part of the orchestra table...but conductors definitely need their own table. They are very independent, some work for several orchestras,
  10. We track a variet of contacts...orchestras, staff and conductors. They all relate to one another (an orchestra can have many conductors, and a conductor can work for many orchestras.) However, we send the same marketing material to all contacts (or selected ones within the groups). Contract A in the example I gave is the orchestra table, Contact B are conductors. I have one event table...1 orchestra table and one conductor table. I want to link 1 event to records in the orchestra table and records in the conductor table. I know I have to do this in two separate actions with two scripts and two
  11. It works!! Yes, it would be nice to find duplicates and such...I'll have to work on that... NOW...I do have a problem. Of course my situation is more complicated than what I originally presented. Not only do I have a table of contacts to join to a table of events...but I have two other tables I want to join to the same event... Let me simplify...as I stated above... Contact A table mass link to an event in Event table. Using Join Contact A | Event....Your solution worked beautifully! Now, add Contact B table mass link to the same event in Event table. I set up the same
  12. You guys blow me away...do you all have IQs of 200+? Amazing. I have been messing around with FM for a while now and although I can come up with some pretty cool stuff, I get totally stumped with the logic in these sorts of scripts. Thank you so much Comment...I think I follow this. I am assuming that you first create the found set in Contacts in this scenario? The script is run from a button in the Event record I want to link to my Contacts found set, right? Like in my second scenario? If I don't first have a found set, then it will try to attach the event to my entire contacts databas
  13. Thanks! I am trying to avoid checking 900 or more names to add the event so I don't think a "picker window" would work...but it is a cool idea! The work flow isn't crucial. Off the top of my head this is how I would intuitively do it: 1. Go to Contact table and create found set through a "Find" based on criteria (selecting the contacts that the event--in this case a mass emailing--went to) 2. Go to Portal on the first record of found set and add the event. 3. Click a button somewhere (in the portal row?) and assign that same event to the rest of the found set. This
  14. Hey... Here is the scenario... Contact table joined to Contact|Event table joined to Event table Portal in Contact table of Event table to see all Events linked to a particular Contact Needing to link 100 (or any number) of Contacts to 1 Event in Event table Do not want to do this manually. I have all the tables and relationships set up and everything works. All I need is a way to create multiple records (joint records in Contact|Event table) in multiple Contact records so I don't have to enter them in one by one...which of course I can do. I figure this wou
  15. Duh...I figured it out...I think. Thanks Ryan....How about the match relationship? I had to relate the date field I wanted found in the portal set (child) to the global date field in the parent. Is that right? It would not work otherwise. My portal refreshed without any other script setting. In the portal filter I had the child date field = the parent global field. It seems to work, did I do it right?
  • Create New...

Important Information

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