I'm working on developing a custom web interface to a major FMP database system we have in place. I've been trying to use ODBC for FMP data but, well, the state of ODBC in FMP Server is beyond terrible.
So, I thought I'd give the XML web publishing a shot. However, I've been unable to get it to send out fields and values for related tables that belong to another db file. The layout in question shows the values with no problem, but it seems that the XML engine will only look at tables within the specified db file (the -db value in the URL).
Is this correct behavior, or am I missing something simple?