check box error w/dynamic values

[tbeidler]

I'm having problems generating dynamic check boxes from dynamic/conditional menus (i.e. each record has a unique "mail_list" check boxes) in FMPro 5 using the following code found on this site;

[FMP-ValueList: mail_list, List=mail_list]

<input type="checkbox" name="mail_list" value="[FMP-ValueListItem]" [FMP-ValueListChecked]>

[FMP-ValueListItem]<br>

[/FMP-ValueList]

The returned source code is without check box html. I think I've checked all the obvious. The field exists in the layout formatted with the value list.

Is it something with FMPro dynamic/conditional menus?

[Vaughan]

I wrestled with the checkbox beast yesterday. Here is the code I got to work...

[FMP-VALUELIST: fieldname, LIST=listname]

<INPUT TYPE=checkbox NAME=fieldnamep VALUE="[FMP-valuelistitem]" [FMP-valuelistchecked]>[FMP-VALUELISTITEM: Always, HTML]

[/FMP-VALUELIST]

Is the value list based on a related field, perchance?

[tbeidler]

Yes it is based on a related field.

Don't tell me...

it can't be done!

[Vaughan]

Is the value list working on a FML layout? Are you using instant web publishing?

A few months ago there was a lot of discussion on this forum about related value lists, with some people posting about their troubles.

Since then I've made a comment about the issue, and other posters have questioned the opinion that they don't work... I've not used them yet (still mainly develoing with FMP4) so cannot give a definitive answer.

If other people HAVE got related value lists to work over the web through CDML, let us know please.

[tbeidler]

The value list works fine in Filemaker Pro 5 and I'm not using instant web publishing.

Once I change the value list to something other then a relationship it works fine with the cdml. But it does nothing once the value list is reverted to a relationship.

I would love to get this one nailed down. It could be very useful in the future.

[Anatoli]

How you set the relations?

[This message has been edited by Anatoli (edited March 03, 2001).]

[Keith M. Davie]

I'm not sure I'm following this correctly, but it seems if there is a valuelist of related fields we are dealing with two databases.

Let's say you have two databases db1.fp5 and db2.fp5. You have established a relationship between the two in db1.fp5 to a field in db2.fp5, which field is set as a checkbox with a valuelist in a layout there. Now you want to access db1.fp5 and use the data in this relationship through checkboxes on your format file.

The problem seems to be that in db2.fp5 you have a field "mail_list", which uses a valuelist, also named "mail_list". But you are in db1.fp5, which is where you think you want to be. And db1.fp5 does not have this field "mail_list". You may have a portal which displays"::mail_list", but "::mail-list" is not "mail_list". And I think, somehow, that is the problem. You actually may be dealing with a portal in db1.fp5, not the valuelist.

But I could be quite wrong.

Peace

Keith M. Davie

[tbeidler]

I select "use values from a field" in the define value list dialog box and select a related field.

I then set the "only related values" in the following specify field dialog box.

[tbeidler]

Ok, here goes. I hope this is clear. Let me know if it isn't.

I have two databases, project.fp5 and email.fp5, with a relationship defined between them. Project.fp5 has a unique numerical id and related files in email.fp5 use the same id. Email.fp5 has a field "name" that lists the name of the individual that should be notified re: the related project.fp5 record.

To create the value list named maillist_vl in project.fp5 I selected "Use values from field:" and I selected email::name. In the following "value list" dialog box I selected the option "Only related values" and I selected the relationship between the two. All of this was done from project.fp5.

Now here's why I'm trying to do this, feel free to lambast me for not using a better approach .

Each record in project.fp5 now has a unique value list for each record which lists the individuals that should receive emails regarding the project. I created a field called maillist in project.fp5 using the maillist_vl value list. If I deselect a box in a record of project.fp5 then the individual deselected will not receive an email. The box can be reselected so the individual would again receive mail.

Does this make sense?

Everything works in FMPro5 but I can't get web companion to generate the check boxes for editing via a browser.