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.

Hi,

I'm not completely sure I understand what your layouts look like, but it sounds like this might be more easily printed using a sub-summary report where 1 layout could print all weight classes with X competitors per class.

Given a found set of all competitors, sort them by their weight class and then have a layout like this:

[SubSummary Sorted by Weight Class] <<Weight Class>>
[body] <<Competitor Name>>

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’t do anything.

At this point I can do the task like this:
On the second data base with portals, I have a Bracket field that I
manually enter
the record found. Then I use this scrip to print. and it works

Set ErrorCapture [on]
If [”Status(CurrentFound Count)>0”]
Print
End If
Go to Layout [2 competitors]
Enter Find Mode[]
Go to Field[Division]
Insert Text[6-7/m/Level 1/U-54/L]
Go to Field[Bracket numer]
Insert Text[2]
Perform Find[replace Found Set]
Sort [Restore,No dialong]
Page Setup
Print[]

This will be ok if I only have 12 divisions but I am talking ages
8-9,10-11, and so on....

I hope this make some sense

Hi,

I still think you may want to try to print these with a summary report, but if all you need to do is count the number of records in the portal, you can do this by counting a related field through the portal, like this:

Count(SomeRelationship::SomeField)