Page numbers

[Aussie John]

I would like to script the page number into a defined field so they can be reused later in a contents page. Unfortunately I don't seem to have the right technique. (see attached file). At the completion of the script the first record shows the total number of pages and the other record shows zero.

in summary the script is

Go to Record/Request/Page

[ First ]

Enter Preview Mode

Loop

Exit Loop If [ Get(LastError)≠0 ]

Set Field [ test::pagenumber; Get(PageNumber) ]

Go to Record/Request/Page

[ Next ]

End Loop

Set Field [ test::pagenumber; Get(PageNumber) ]

Go to Record/Request/Page

[ First ]

Enter Browse Mode

test.fp7.zip

[comment]

I am afraid this is a bit more complex than that - see;

http://fmforums.com/forum/topic/30553-index-page-or-table-of-contents

[Aussie John]

I am afraid this is a bit more complex than that - see;

http://fmforums.com/...ble-of-contents

Thanks and indeed - especially as some of the records are multiple pages. I solved this by running a check script which opened a new window via a self relationship to count the number of pages of that record. and adjust. This is a bit clunky but seems to work. The contents page uses the calculated page number and the main body of records use the built-in page numbering system ("//").