Go to related record via an html page

Partha · June 8, 2001

Hi,

I'm trying to figure out how to go to a related record via an HTML page served up by Web Companion (custom publishing). I can, of course, put the related data on a layout in the first file, and vie it through the '-lay' command.

Problem is, that the related record has its own related data that I can only view if I go to the related record in the 2nd file. I've tried the "-Script" command, but whether I reference the first or second file in the "-lay" & "-DB" commands, I get an error.

Any suggestions? shocked.gif" border="0

iBib · June 8, 2001

In which way is it related?

Is the field in the first layout a related field or a "local" field with related content?

Garry Claridge · June 8, 2001

You may have to create 'Calculated' fields which display the related data rather than a portal. Than refer to the 'Calculated' fields in the CDML tags.

All the best.

Garry

Jeff Spall · June 8, 2001

Hi, hope this might help:

We had a web database which was a directory of companies where their products, branches, brand names, contacts etc. were all in related files. The companies could create or edit their details online.

The related files showed as portals on the main record detail, but I used "edit conacts" (etc) buttons to link to the related records. I just made it a search which had the record id (the relationship) embeded in it. Looked like this:

</FORM>

This worked fine for some really cruddy relationships (ported from Access !!! !) and let the user edit, create and delete in the related files - just make sure to carry the relationship field as a hidden value over into new records.

regards, Jeff

iBib · June 8, 2001

A copy of what I wrote to Partha in an e-mail:

>Hi Partha

>

>It's hard to distinguish the problem without looking at your

>specific databases, but i'll give it a try.

>

>My way of doing what I think you want to do is using a set of

>InlineActions (or inlines if you use lasso) and send tokens with id

>numbers for the records which you need to show between the

>inlineactions. I believe it would work, even though it would require

>some work on your behalf.

>

>I hope it helps

>

>/William

(I post it here so that someone can comment on it)

wink.gif" border="0

[ June 08, 2001: Message edited by: iBib ]

Garry Claridge · June 9, 2001

Partha,

I have made some assumptions based on your email and notes here. The comercials db has a one-to-one relationship with the brands db, and the brands db has a one-to-many relationship with the personnel db. That is one commercial has one brand, and one brand can have many people associated to it.

I use a frameset with two frames. The first frame lists the commercials and the related brands. The second frame lists the personnel related to the brand.

The tvc_brand_name field in the commercials db is a calculated field using the brand_id relationship to display the brand_name from the brands db.

This format file lists the Commercials and the related Brands:

<head>

function paxfmsub(brand) {

document.paxfm.brand_id.value = brand ;

document.paxfm.submit();

}

</script>

</head>

<body>

[FMP-Record]

[FMP-Field:tvc_name] <a href="javascript tongue.gif" border="0 axfmsub('[FMP-Field:brand_id]');">[FMP-Field:tvc_brand_name]</a><br>

[/FMP-Record]

</form>

</body>

My assumption that the 'brand_id' is the common key across all databases may not be similar to your data-structure, as is my assumption that a commercial has only one brand associated to it.

Hope this is heading in the right direction.

Garry

Partha · June 9, 2001

Hi,

Getting all these replies is a great feeling. I've tried 2 of them, both work.

However, the commercials have one or more brands associated to them through the "Brand_ID", so I've finally taken the easy way of pushing the Brand_ID's to one or more searches in the brand file, and then showing the data through a layout in the brand file.

Thank you to everyone who responded, and helped me think this problem through.

Rgds

Partha

Partha · June 21, 2001

Thanks a lot to everyone who helped me out, especially Jeff who put up some of his pages, and pointed me in the right direction.

To put it in brief, I needed to go to a 3rd related file based on values from a second related file. Since there is no "Go to Related Record" in CDML, the workaround I did is picked up the values and sent them forward in a "-Find" http string linked to the 2nd level related file being displayed in my web layout

Jeff Spall · June 21, 2001

Hi!

since you posted the original question, I've had to do just the same thing. I ended up with a simple link in the portal that looks like:

<A HREF="http://www.mydomain.com:591/myfiles/FMPro?-db=mydatabase&-format=record_detail.htm&-error=search_error.htm&-lay=layout1&-op=eq&recordkey=[FMP-field:status::recordkey]&-find"

where there's just a field embedded in the search.

works a treat smile.gif" border="0

regards, Jeff

Sign In

Go to related record via an html page

Recommended Posts

Partha

iBib

Garry Claridge

Jeff Spall

iBib

Garry Claridge

Partha

Partha

Jeff Spall

Create an account or sign in to comment

Create an account

Sign in

Browse

Site Support

Forums

Blogs

Marketplace

Activity

Important Information