Jump to content

This topic is 8282 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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]

Posted

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

Posted

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.

Posted

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 smile.gif

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.