Database A Database B

[Turansky]

Hello,

I have database A that has a auto entered serial number field called eventID. And I have a database B that has a text field called eventID.

I have done a find and listed out all the database A records and now want to list database B records based on if eventID (A) is matching eventID (:

Right now it is listing all the records from database B. Does anyone see what I have done wrong?

<a href="http://xxx.xxx.xxx.xxx/FMPro?-DB=scoe_roster.fp5&-Format=scoe/rosterlist.html&-Lay=roster&-eventID=[FMP-field: eventID, url]&-Max=all&-Find">

Thank you

Kent

[Keith M. Davie]

When all the records are returned, go to the db scoe_roster.fp5 and perform a Modify Last Find. It will show you what data was entered upon which the find was acting.

[ February 19, 2002, 06:16 PM: Message edited by: Keith M. Davie ]

[Garry Claridge]

Kent,

Should this:

&-eventID=[FMP-field: eventID, url]&

be:

&eventID=[FMP-field: eventID, url]&

Garry

[Turansky]

Gary you where right about the hypen. So now I am getting my results. Within the results I am trying to call out to Database B and have it display some results. The results are not displaying? Keith I took your advice and the "Modify Last Find" is {participantID} So I think this is my problem but not sure. There is a participantID field in each database also.

[FMP-Record]

[FMP-field: eventID] [FMP-field: participantID]

FMP-InlineAction: -db=scoe_participant.fp5, -lay=participant, participantID={participantID}, -find]

[FMP-field: first] [FMP-field: last]<br>

[/FMP-InlineAction]

[/FMP-Record]

Thank you

Kent

[ February 19, 2002, 07:42 PM: Message edited by: Turansky ]

[Garry Claridge]

Kent,

I would use a portal in Database A. First, set-up the Relationship from DB A to DB B, based on the EventID field. Then in Layout mode create a portal on the 'participant' layout. Add the relevent fields to the portal.

Now your cdml would look like this:

[FMP-Record]

[FMP-field: eventID]

FMP-Portal: myrelationship]

[FMP-field: myrelationship::first] [FMP-field: myrelationship::last]<br>

[/FMP-Portal]

[/FMP-Record]

This may be a bit easier than passing values to an [FMP-InlinAction]. Unless an intratag exists like {field:eventID}.

All the best.

Garry

[ February 19, 2002, 07:54 PM: Message edited by: Garry Claridge ]

[Turansky]

Your right that would work Gary, but I just figured out my mistake.

participantID={participantID}

should have been

participantID={FMP-field: participantID}

I kept going back to what Keith said and there must have been a reason for the last find to be {participantID}

Thank you Gary and Keith

By the way Keith I bought two books you recomended. Research is good for the soul!

Kent

[Keith M. Davie]

Kent, You're welcome. I'm glad my suggestion helped.