Help!

[woo]

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.

[woo]

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.

[mr_vodka]

Hi Woo,

Can you further describe what it is you are trying to do?

[mr_vodka]

Hi Woo,

Can you further describe what it is you are trying to do?

[woo]

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.

[woo]

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.

[woo]

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.

[Søren Dyhr]

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

[woo]

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

[Søren Dyhr]

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

[woo]

Count(bracket number)