I'm not new to FMPro, but new to XSLT. I've used the FM Site Assistant to get me started on just showing the information. I understand how to go in and edit the information a bit and how to change how it's displayed. But then I wanted to pull the formatting from FM like the IWP does. I read a bit and found this in fmsa7_custom_web_guide.pdf

"You can incorporate a FileMaker database

The "document()" gets the result XML for the layout information. It's pulled into the variable "layout" and stored for later usage in the XSLT.

Check your created XSLT and see if you can find the variable used elsewhere, something like: select="$layout/fml:FMPXMLLAYOUT/fml:LAYOUT/fml:FIELD[@NAME = 'Category']/fml:STYLE/@VALUELIST". This is accessing the XML from the variable and using it for things like valueLists.

The "document()" is a pretty *powerful* way to bring in 'other xml sources'!!

HTH

Let me start out by saying thank you for your reply. I see you are on here helping a lot of people . I've been sitting here for awhile not trying to make an honest attempt at understanding how this works. Yet it continues to stump me.

So, I ask for more help in an example.

Setup: A FMPRO 7 database named "my_database" with a table named "table1" and a field named "field1" that changes text color based on a calculation of a value in

Have you looked at the "GetAsCSS()" function? If you have a field with particular color text, it will give you the 'style' that the browser can read.

Look at the CWP user guide for more information on what is extracted from the LAYOUT.

=== blatent copy ===

"Description of elements in the FMPXMLLAYOUT grammar

In the FMPXMLLAYOUT grammar, the <LAYOUT> element contains the name of the layout, the name of the database, and <FIELD> elements for each field found in the corresponding layout in the database. Each <FIELD> element describes the style type of the field, and contains the VALUELIST attribute for any associated value list of the field.The <VALUELISTS> element contains one....

Thanx again for your time... I will look into this.

I found a solution to what I was looking for in the IWP pages. Although this doesn't allow for customization like xml does. It displays the information the way I want it... just like the layout.

http://<webaddress.com>/fmi/iwp/cgi?-db=<DATABASE>&-lay=2&-gotolayout=

This was a reply by seanc under Instant Web Publishing Forum - How to set the start layout page? (Posted By Brad Neal)