August 20, 200223 yr Arrrrghh..I am having a tough time getting a related field to show up in a search result..Currently have 2 DB's orderitems items Relationship between the 2 called "sku" in orderitems, it will pull the "description" from items based on a matching sku. sounds simple enough! and it's working in the FMP side, the data is pulled over OK. here is my CDML - this is the whole file <HTML> <HEAD> <TITLE>al;skdfj</TITLE> </HEAD> <BODY BGCOLOR="#FFFFFF"> <P>[FMP-RECORD] [FMP-FIELD: sku] [FMP-PORTAL: sku] [FMP-FIELD: sku :: Description] [/FMP-PORTAL] [/FMP-RECORD]</P> </BODY> </HTML> this currently will show me just the SKU #'s from the file...will not pull any descriptions from the related file.. does something look obvious to anyone? FMP 5.5 OSX/OS9 WC 5.5V4 thanks! cory
August 20, 200223 yr The only thing that looks obviously awry to me are the spaces within your related field name, i.e. the spaces before and after the ::, but I suspect you formatted it that way so that UBB wouldn't turn your CDML into a graemlin. Am I correct? Also, I know that CDML is supposed to be case-insensitive, but you may want to write your tags in "proper" case, i.e. [FMP-Field: sku]
August 20, 200223 yr Author thanks for the reply.. I did try to remove the spaces & caps, still have the same results. this was a file that I made using claris homepage, just drag and drop, so I don't think it's anything with my syntax on the CDML file..but the FMP file also seems to work just fine as well.. I'm not sure what to look at next.. maybe just rebuild the FMP files/relationships
August 20, 200223 yr Bridge, you missed an opportunity, "The only thing that looks obviously awry ..." could have been "The only thing that looks obviously asku ..." As to the rest of it, I see some problems, which I will address later. Right now I've go to go. Tah tah.
August 20, 200223 yr Author ugh.. that was it, I wasn't specifying a -lay in my link..seems odd it didn't give me an error, and still rendered everything else OK except the relationship.. I appreciate the help with it! now if I can find those last 2 hairs I lost
Create an account or sign in to comment