Generate Portal records with a Checkbox system

[chikanyc]

Hi Everyone,

Does anyone know how to create portal records using checkboxes?

I have 3 tables:

(1) Products

(2) Tags

(3) Products to Tags (similar to a Line Items Table)

For each product record, I want to have a layout that displays ALL tags (400 or so) in a checkbox format. Every time a user checks or de-checks a tag in the checkbox, I want a record created or deleted in the Products-to-Tags table. So every record in the Product-To-Tags table will have the foreign key fields of the Product UID and the Tag UID. Also, I want to be able to see what has been checked off as I'm checking in the checkbox..

I understand that this isn't the simplest way to keep track of relevant tags for a Product record, but this is what our MySQL search engine expert requested. (He doesn't have FM experience, and since my company keeps tracks of everything via FM, we want to do this in FM. In the past, we kept track of tags, in a tag field without creating having to generate LineItem records.)

Thanks for reading guys! If anyone could offer any help, I'd be very grateful!

[comment]

See if this helps:

http://fmforums.com/forum/showpost.php?post/340683/

[chikanyc]

wow this looks super promising! gonna check it out!

thanks comment!!!!

[chikanyc]

comment, thanks again -- this is just what i was looking for!

but do you know how to get those custom checkboxes to appear/work the way that they do in the example?

[chikanyc]

whoops got it! conditional formatting! silly me:p

sorry for the trouble!

thanks:)

[chikanyc]

ok i spoke too soon. The conditional formatting isn't working for me for some reason. I've gone over it and over it and can't figure out where I've gone wrong.

Also, I tried to mimic the script that was in the example zip, but it won't delete ObjectAttribute records in my DB..hmm.