Corys Posted August 20, 2002 Posted August 20, 2002 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
The Bridge Posted August 20, 2002 Posted August 20, 2002 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]
Corys Posted August 20, 2002 Author Posted August 20, 2002 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
Keith M. Davie Posted August 20, 2002 Posted August 20, 2002 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.
Garry Claridge Posted August 20, 2002 Posted August 20, 2002 Is the result coming from a Layout with that Portal on it? Good Luck. Garry
Corys Posted August 20, 2002 Author Posted August 20, 2002 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
Recommended Posts
This topic is 8282 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now