cdml - "go to related record" equivalent 1

[unicornisalba]

Hi FMPro people!

I have a question about displaying data from a related file.

I've designed the membership database for Calder Connect Co-operative (

http://www.3-C.CoOp),

a local (Calder Valley, West Yorkshire, UK) community-based broadband ISP, which we've set up as a co-op (as far as we know, the first in the UK). It has 14 files in it.

I've been using FIleMaker for over ten years now, but I've only just started exploring custom web publishing.

This solution is in FMPro 4, because of the hits-per-day restrictions of 5. No, we can't afford Unlimited, before anyone suggests it!

It was originally going to be available online through FMPro itself, but I found it so unbearably slow, as to be unusable.

So I need to build a web interface as a matter of urgency, as we are already taking orders, and our workers need to use the database. Time is not on our side!

What I'm trying to do is this:

1) list all members according to search criteria (members.fp3)

2) display details for each member (members.fp3)

3) list all the "problems" for that member (problems.fp3) - not as a portal, because I'll need to go down another level, to "actions.fp3"

NB. "members.fp3" and "problems.fp3" have a one-to-many relationship, using the numeric field "member_key" in "members.fp3", and "member_match" in "problems.fp3".

I've done (1) and (2), but I'm completely stuck on (3).

I've searched the forum, but without success. If anyone can tell me how to do this, rather than where to look, I would be very, very grateful. And I'm sure it would be useful for other newbies, too.

Thanks.

 

[lebisol]

there are templates and CDML refrence files that can get u started....FMPro will work just as fine (10 IPs limit)....portals are very duable on the web.....Scripts are NOT.....
about (3) -what do u mean "go down" ...then the DB is realted or there is NO "down" -parent-child?! I hope that the DBs at least share some common ID that can be used to look up
goto:

http://filemaker.com/downloads/index.html

hit Ctrl+F and type "CDML" it will find the link (on the right hand side) and download the tools (templates)
BE CAREFUL when doing design with CDML+HTML as the security is an issue....be ready to use your JavaScript.
a lot of good reading at:

http://www.fmforums.com/threads/postlist.php?Cat=&Board=UBB22

if u need a quikc&dirty:

What it does
	[FMP-CurrentRecID] is replaced with the record key—a number representing the current record.

	If [FMP-CurrentRecID] is placed between the [FMP-Record] and [/FMP-Record] tags, [FMP-CurrentRecID] is replaced with the record key of each record in the sequence.

Syntax example(s)
	Delete a record using a form action
		<form action=&quot;FMPro&quot; method=&quot;post&quot;>
			<input type=&quot;hidden&quot; name=&quot;-DB&quot; value=&quot;name.fp5&quot;>
			<input type=&quot;hidden&quot; name=&quot;-Format&quot; value=&quot;results.htm&quot;>
			<input type=&quot;hidden&quot; name=&quot;-RecID&quot; value=&quot;[FMP-CurrentRecID]&quot;>
			<input type=&quot;submit&quot; name=&quot;-Delete&quot; value=&quot;Delete This Record&quot;>
		</form>

	Display a hit list using [FMP-CurrentRecID] instead of [FMP-LinkRecID]
		[FMP-Record]Click <a href=
			&quot;FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=[FMP-CurrentRecID]&-Find&quot;>here</a>
			to view record [FMP-CurrentRecordNumber].<br>
		[/FMP-Record]

		<!-- After processing, the HTML sent to the browser could look like:
			Click <a href=&quot;FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=1&-Find&quot;>here</a>
				to view record 1.<br>
			Click <a href=&quot;FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=4&-Find&quot;>here</a>
				to view record 2.<br>
			Click <a href=&quot;FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=10&-Find&quot;>here</a>
				to view record 3.<br>
		-->

See also
	-RecID, [FMP-LinkRecID]
[code]

All the best!

> need more info? 
:: don't click HERE ::

 

[unicornisalba]

Thank you very much for your detailed reply, Lebisol.

After some discussion, it has been decided to hive off the payment tracking and support tables as separate databases. This will make life a lot easier, but it's going to take me a while to get to that point.

I intend to make the new databases just to hold the data and relationships, without worrying about layouts (apart from what the web companion needs) or scripts. Bliss!!!

Yes, I always design my tables to have unique, unmodifiable keys, and all non-primary tables have match fields (2 or more in the case of line items files) as well as key fields. What I don't really understand is how I pass this unique key to another file for processing. Is this what "tokens" are for?

Once I've sorted out the structure and exporting procedure of the three databases, I'll try out your suggestions.

I'd also like to get a book or two, but the problem is I'm using FMPro 4 (the user limit would make it useless for us). Anyone know of a book that would be suitable?

 

[lebisol]

if u like to take your time and do it really inexpesivly:

http://www.fmwebschool.com

tokens- yes and + more than that
passing is actually done by FM synthax that interprests "currently viewd record"...unique key is already "added" by the fact that ur viewing-clicking and FINDing by URL- that record

<!-- After processing, the HTML sent to the browser could look like:
Click <a href=&quot;FMPro?-DB=db.fp5&-Format=rslt.htm&-RecID=1&-Find&quot;>here</a> to view record 1

tokens also can be passed by URL or FORM submittion...they can be passed throught the pageS (like session) while currentrecID will take only that 1 step more to details....anyhow.

All the best and good luck!

also consider using Lasso for more security than CDML...although it costs $$$$




> need more info?
:: don't click HERE ::