woo Posted March 21, 2005 Author Share Posted March 21, 2005 Can I have a field that add portal records? I hope I am asking the this right. On the portal,say five names from related record. I need a field that add portal records by showing #, so that I can do the find surch for all record that has five record. Link to comment Share on other sites More sharing options...
woo Posted March 21, 2005 Share Posted March 21, 2005 Can I have a field that add portal records? I hope I am asking the this right. On the portal,say five names from related record. I need a field that add portal records by showing #, so that I can do the find surch for all record that has five record. Link to comment Share on other sites More sharing options...
mr_vodka Posted March 21, 2005 Share Posted March 21, 2005 Hi Woo, Can you further describe what it is you are trying to do? Link to comment Share on other sites More sharing options...
mr_vodka Posted March 21, 2005 Share Posted March 21, 2005 Hi Woo, Can you further describe what it is you are trying to do? Link to comment Share on other sites More sharing options...
woo Posted March 21, 2005 Author Share Posted March 21, 2005 I am working on a taekwondo weight division bracket looking like NCAA march madness. In one of the portal layout, there are six weighy divisons. Some division have three competitors nd other have five and some division do not have any. So when there are five competitors in one of the weight division, I want FM to got the lay out aht has five person competitor bracket and print, but if there on competitors in the dvision don't print. At this point I could do all of the them except having bracket field which I have to manually put numbers in after counting the competitors in the portal. Then I do the find in each bracket layout to search for matching mumbers. Here is a sampe of my scrip If[status(CurrentFoundCount)<O Print[] End IF Goto Layout[2competitors] Inter Find Mode[] Got field["Bracket"} Insert Text["2"] Perform find Page Setup Print this continues up to 8 layouts I need the bracket field to automatically put right numbers in. Link to comment Share on other sites More sharing options...
woo Posted March 21, 2005 Author Share Posted March 21, 2005 I am working on a taekwondo weight division bracket looking like NCAA march madness. In one of the portal layout, there are six weighy divisons. Some division have three competitors nd other have five and some division do not have any. So when there are five competitors in one of the weight division, I want FM to got the lay out aht has five person competitor bracket and print, but if there on competitors in the dvision don't print. At this point I could do all of the them except having bracket field which I have to manually put numbers in after counting the competitors in the portal. Then I do the find in each bracket layout to search for matching mumbers. Here is a sampe of my scrip If[status(CurrentFoundCount)<O Print[] End IF Goto Layout[2competitors] Inter Find Mode[] Got field["Bracket"} Insert Text["2"] Perform find Page Setup Print this continues up to 8 layouts I need the bracket field to automatically put right numbers in. Link to comment Share on other sites More sharing options...
woo Posted March 22, 2005 Author Share Posted March 22, 2005 I am working on a taekwondo weight division bracket looking like NCAA march madness. In one of the portal layout, there are six weight divisons. Some divisionsnd have three competitors andnd other have five and some division do not have any. So when there are five competitors in one of the weight division, I want FM to go to the lay out that has five person competitor bracket and print, but if there no competitors in the dvision don't print. At this point I could do all of the them except the bracket field which I have to manually put numbers in after counting the competitors in the portal. Then I do the find in each bracket layout to search for matching mumbers. Here is a sampe of my scrip If[status(CurrentFoundCount)<O Print[] End IF Goto Layout[2competitors] Inter Find Mode[] Go to field["Bracket"} Insert Text["2"] Perform find Page Setup Print this continues up to 8 layouts I need the bracket field to automatically put right numbers in. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted March 22, 2005 Share Posted March 22, 2005 So when there are five competitors in one of the weight division, I want FM to got the lay out aht has five person competitor bracket and print, I thought about your problem and it seems like you could exploit the fastsummaries technique by Michail Edoshin at: http://www.onegasoft.com I've made a template in 7.0 showing how to (because I forgot to see which version you were on, I'm so sorry) - but If you download a trial version of 7.0 might there be a chance you get the reasoning behind - and how to convert it to 6.0??? I do also list the scripting if thats better, but the way it works is that it sifts throug all portal records not just the ones belonging to a particular maintable record but all and find every groupings containing exactly 5 records, and sets a global value in the maintable (...please not that before 7.0 was the relations not bidirectional so you have to establish an opposite pointing relation as well) When the global field contains some keys is a GTRR performed to single out the main table records containing exactly 5 portalrows. Set Field [ OnlyFive::g_SJKey; "" ] Go to Related Record [ From table: "Portal"; Using layout: "Portal" (Portal) ] Sort Records [ Specified Sort Order: Portal::BelongsTo; ascending ] [ Restore; No dialog ] Go to Record/Request/Page [ First ] If [ GetSummary (Portal::Breaker;Portal::BelongsTo ) = 5 ] Set Field [ OnlyFive::g_SJKey; OnlyFive::g_SJKey & " OnlyFive.zip Link to comment Share on other sites More sharing options...
woo Posted March 22, 2005 Author Share Posted March 22, 2005 I am new at this and you sound like what you are talking about. I have no clue what you are saying. Let me try one more time what I am trying to do. Martial Art Tournament Brackets I have one date base that I inter Name, gender, age, weight, and Belt Rank Than I have another date base with portal lay out and Bracket drawings. In the bracket drawings I have portal laidyered. I have 12 portals in my lay out (12 divisions) Portals 1 contains Male, age 6-7, weight 54lb and under and Yellow belts. I have field that when these are matched (6-7/m/Level 1/U-54/L) This is what I want FM to do on the data base with portals: If Portal contains 2 record than go to layout 2 bracket and print. If Portal contains 7 record than go to layout 7 bracket and print. No records don Link to comment Share on other sites More sharing options...
Søren Dyhr Posted March 22, 2005 Share Posted March 22, 2005 I hope this make some sense Honestly no I ain't got the faintest clue, could you off forum send me your files ...and then might I get the reasoning in it??? --sd Link to comment Share on other sites More sharing options...
woo Posted March 24, 2005 Author Share Posted March 24, 2005 Count(bracket number) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7160 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now