pull random record on a format page

[kmillar]

I have a link to a format page:

FMPro?-db=Inventory&-lay=Detail&-format=search.html&-view

On the format page "search.html", I have a form to query the database.

I want to add a RANDOM record from a different database on the same format page "search.html" so I put an FMP-InlineAction code, but no data is displaying on the page.

[FMP-InlineAction: -DB=Specials, -findany] On special this week!

Manufacturer: [FMP-Field:Mfr] Model: [FMP-Field:Model]

Our Price: [FMP-Field:Our Price]

[/FMP-InlineAction]

This code is placed after the form to query the Inventory database.

Can anyone tell me what I am doing wrong and if it is possible to do this?

Thanks!

Karene

PS I did post a request for someone to help me implement this as a subcontractor, but I have not received any responses and I need to get this finished ASAP.

[Garry Claridge]

I think you will need to name a Layout, e.g.

[FMP-InlineAction: -DB=Specials, -lay=mylayout, -findany] On special this week!

Manufacturer: [FMP-Field:Mfr] Model: [FMP-Field:Model]

Our Price: [FMP-Field:Our Price]

[/FMP-InlineAction]

All the best.

Garry