sdl

Thanks comment! I didn't realize you could just add onto the variable like that. I love learning new things! Thanks!

Hi Comment ... thanks for the reply. I figured it was a looping situation which I'm not fully versed in but I get it enough to experiment until I find the right solution. But I'm not sure how to keep adding onto a variable. I know how to create or change the variable but not certain how the formula for the variable would look to change it to keep tagging onto the end. Can you offer advice on this? And I'm REALLY not sure what a recursive function is but I'll do some googling.

HI Fellow FM'ers, You're always so helpful and respectful to us lay folk that I hope you can assist on the following. It seems like it should be easy but I can't seem to find the solution If I have a set of records (let's say 30) and each record has a LOCATION field, I am trying to create a google map URL syntax in which I need to get the various locations from each record. So in broad terms it would look like "Location(from record 1)&","&Location(from record 2)&","&Location(from record 3), etc. " -or- "Tulsa, Houston, Dallas, etc" I've tried a List(Locations) but that only gives me a single value. I'm kinda stumped on this one. Any insight or starting point is appreciated. Thanks SDL

Hey comment ... Sorry my bad ... I said Tab and should have said portal. I managed to figure it out. had a couple relationships askew. Just doing a simple horizontal viewer. Working fine now but using FM11 would be so much easier as it has portal filtering built in rather than having to create a work around. Thanks again for the reply

lol ... TRUE <--- get it ... true :)

Is it possible to display a Related Record in a different tab? Yes, I can set it up to view in a different layout Or I can view it on the Current Layout But I can't seem to figure out the work around on how to select the record in a portal on Tab A and have it appear in a detail layout located on Tab B. Is this an easy fix? Thanks in advance. The folks on this forum are fantastic and generous with their time.

Dooh! of course. I knew it was some type of Boolean but I forgot about looking at the formatting rather than the field definition. I also figured out where my error was. It wasn't in the portal setup per se. It was in the setup of the button. I had a graphic in the portal and I was using that as a button. I didn't put the graphic in a container and therefore it wasn't really a part of the record. It was just a graphic. Comment, thank you so much for your help on this! Very nice of you to take the time to make that down and dirty file. That made all the difference! Cheers sdl

It is working. I've got to step away and I'll come back ... but the one thing I can't understand is how a number field (Status) with no calculation is coming back in the portal as "True" or "False". Normally if I put a number field in the portal it comes out a number field. I can't for the life of me figure out why it's coming out as a logical text result. What would I do if I wanted to show the numeric value of Status?

no luck Comment .. unless I misunderstood something. Here is the photo I think I've got the portal and TO exactly the same and this is what I reference in the script ... you can see both in the photo. Did I misunderstand?

Would any of you consider donating about 3 hours of consulting to this military project? I'm not sure if this is the best category to post this but it's a generic request. I'm currently working on a national fundraising tour designed to raise $1.8 million for the families of the 154 fallen Canadian troops as well as the thousands of injured soldiers, sailors and aircrew. This tour will travel across Canada for one year and will bring Canadians together to honour, remember and celebrate our troops. And of course to raise funds. As you can imagine, developing a tour of this magnitude (over 200 stops) requires a database and I've got a good relational DB well on its way. I'm no newbie to FM (I actually go back to the Claris v1.0 days) but I use it in a fairly basic way and not an elegant one. Every once in a while I hit a hurdle (or three) and it would be great to speak with a consultant. If you are interested I can fully brief you on the Tour project and on the database hurdles.

I hope I'm not overstaying my welcome here but another question that is driving me crazy but likely something simple ... Here are some photos to start: Here's my layout. The layout as you see,is showing EVENTS which is a parent table. It has two key parts. The top part is showing Event details straight from the table. The lower part is the portal that I discussed earlier. Here is the relationship. cTrue is a calculation = 9 and if my Event_Priority = 9 then it's equivalent to inactive. Here's the RG in case that helps: So what is the issue: Well all I'm trying to do is click on the portal list and have that record populate in the top half. But regardless of the various RelatedRecord scripts that I try to create I get an error of "target is not part of a related table". I'm guessing I"m missing something obvious but after a couple hours of trying different things (ie changing the layout (get records from) and changing the script step to try different relationships I'm stumped. Any advice is most appreciated. Wow Comment I sure wasn't expecting an answer on a weekend. You rock sir (or Ma'am)

Thanks so much for taking time to grab me by the hand Comment. Your self-join worked perfectly and now I can see the whole redundancy path that I was starting to head down unnecessarily. It did invoke a new question from me though ... when is it appropriate to use a Number(with calculated value) versus using a Calculation (with number result)? I learned the hard way on a previous issue that one of my relationships couldn't use a Calc(number) but worked perfectly with Number(calc). Just curious. Thanks again to you and all others who take time to help mentor

Hi "Comment" Thanks for the quick reply. I'm still confused and almost embarrassed to post on the forum for fear of sounding like a total doofus. My list of Events is shown in two places. One is on a layout in just the body section. The other is in a portal. The portal has a SelfJoin relationship where z_g_SelfJoin and z_g_SelfJoin are equal. So that way I get all events listed in the portal. I'm not familiar enough with the not logical function. So I'm confused on how to set up the relationship. In terms of the regular layout I guess I could use an Onlayout script trigger to trigger a find and sort to eliminate the inactives. But not sure on the self-join. I am sorry I'm not being quick on the uptake.

I'm going to resurrect an old thread because I'm in the same boat and my head is spinning ... coding for way too many hours. Simple Scenario: I need to plan over 200 events across the country in several months I have a table of EVENTS which contains all possible events However some events aren't feasible as they conflict. That said, I don't want to delete them completely. Yes, I could mark them as inactive and I have that but they still show up on my calendar, event list, etc. Yes, I could struggle to find complex trigger scripts to filter out the inactives but I'm not that smart So I was hoping I could just create a new table called EVENTS_ALL and whenever I create a record in EVENT, it creates the exact same record in EVENTS_ALL. And if I delete a record in EVENT I still have a record of it in EVENTS_ALL. I could create a massive Cut/Copy script for each field but I know that's not the answer I could create a button that I could press AFTER I create the EVENT to export the record over to EVENTS_ALL but what if I forget to. And I can't see a script trigger that works that way. uggg.... head spinning. Help appreciated.

I've tried to but not successfully. In the simplest of terms: I have the following two simple tables Table 1 ClubName Latitude ( ie. 63.500) Containing records: Calgary - 51.543 Edmonton - 51.890 Saskatoon - 48.999 Toronto - 41.876 Table 2 PersonName Latitude Containing records: Sam - 49.625 And assuming for a moment that I want to show (in the portal) all the Club records that are greater to Sam's location I created the relationship ClubsName:Latitude < PersonName:Latitude It should show in the portal 2 records (Calgary and Edmonton). I'm sure I'm missing something obvious but ugghhhh I can't figure out what.

Hi folks ... after 5 hours of solid head beating, googling, experimenting and no luck ... I turn here. I have a script that works well when fired manually. But if I try to use it as a layout script trigger it loops. I understand why (I think) but I can't devise a work around. Here's the background. - I have two tables (Clubs and People) - records in each table contain geocode information (latitude/longitude) - I can run a script that determines the Person's location and can then calculate a secondary set of latitudes and longitudes that represents a 50 mile radius. (ie if latitude was 10.0 and I calculate latitude-variation and latitude+variation I will get a latitude search string of, for sake of argument, 8.5 ... 11.5 and then do the same with longitude) - I can then plug this search string into the Clubs table and find the clubs that exist within that 50 mile radius. I give this foundset a global value (2) - In my People page I have a portal that displays these results based on a relationship where the People page also has a global value of (2). Here's the problem - If I run this script manually, no problem. Works slick - But I want to be able to advance record by record in the People section and have the portal populate with the Clubs in the vicinity of the Person. - The rub seems to come when it flips from layout to layout (even though it's faster than the human eye) it repeatedly sets off the trigger. Hence the loop - I've tried OnRecordLoad, OnRecordCommit, OnLayoutLoad and even OnModeEnter. Same results. - I can't seem to be able to set the fields for the find request without switching to the Club layout and then I have to switch back to the People layout to see the results in the portal. Any suggestions or work arounds? I appreciate you consideration. Cheers