Hi, I have 3 db's. On main page is a list (overview, organization, etc).

From here user clicks on one (we'll use organization - each link is the same format). All is links, no forms:

<a href="FMPro?-DB=OPD_OrgMain.fp5&-Format=OrgList.html&-SortField=Organization&-FindAll">Organizational Listings</a></td>

clicking on this displays all the organizations which has a similar link which displays all departments within each organization.

On the departments page I want them to click on a department and see all the people associated with that deparment.

<a href="FMPro?-DB=OPD_OrgInst.fp5&-lay=List&-Format=Org_Inst.html&SortField=calc_fullname_abbrev&-Max=10000&-Find">[FMP-FIELD:

calc_org_abbrev]</a></td>

But here I need a search field, "&searchfield=[FMP-currenttoken]", the token would be the department.

How would I set a token like this? I'm just not understanding where this would be set and I've tried several things but, clearly, they ain't workin!

thanks,

ricardito

You would set (define) the token(s) in the link "Organization Listings" (your first example).

It could read in part something like "...&-token.0=giraffs&-token.1=elephants&-token.2=moose&-token.3=janitorial..."

You are allowed up to ten tokens, so if there are more than ten departments, you will have some design problems to overcome.

You would then use the appropriate token in the next link. I believe that the proper syntax might look like "...&searchfield=currenttoken:2&-find">".

Belief is one thing, and

IMHO the -Max=10000 should be shortened to 1000 max. 10000 will probably time out in WC.

Maybe I do not understand the problem, but isn't the [FMP-LinkRecID] better for the job?

Could you use something like this:

<a href="FMPro?-DB=OPD_OrgInst.fp5&-lay=List&-Format=Org_Inst.html&SortField=calc_fullname_abbrev&calc_org_abbrev=[FMP-Field:calc_org_abbrev]&-Max=all&-Find">[FMP-FIELD:

calc_org_abbrev]</a>

Good Luck.

Garry

Thanks for all the advice. Garry, you da man! No tokens necessary. I had tried this before but had made a small error. On revisiting it I saw my mistake and voila!

Much obliged.

r