June 21, 200421 yr Hi...I posted this under the "Fields" topic, but someone suggested that this topic might be better. (They were right.) I am very new to Filemaker and Claris Home page, but so far so (reasonably) good. I do not have CDML experience, but I have been using HTML and HTML forms for years, so I can customize the output that Claris Homepage produces with its Filemaker Connection Assistant. I have a question about how checkboxes interact with the FM database. I'm using FM 6.0 and have used Claris Homepage to create the Web interface to the database. I'm then customizing the HTML pages. When I created the interface with Claris, I instructed the one field (Editor/Designer Name) to appear as a checkbox and to allow multiple entries. In the HTML file, for the checkboxes, this appeared once: [FMP-VALULIST: Editor/Designer Name, LIST=-Editor/Designer Name] <checkbox symbol> [FMP-VALUELISTITEM: Always, HTML] [/FMP-VALUELIST] The field (Editor/Designer Name) is derived from a value list that contains about 30 names. How can I get each of these names reflected in the Web interface AND do so in a way that allows the user to view a record and ADD new checkmarks to a record without overwriting the existing ones? I tried to fix this in the HTML by creating a radio button for each of the people in the Editor/Designer value list and associating those radio buttons with the correct field. This works, but it overwrites existing checked entries in the database. For example, imagine that a user is viewing a record with a checklist that looks like this: __ parsley __ sage __ rosemary __ thyme and record #1 indicates that a user has checked these items: X parsley X sage X rosemary __ thyme Another user sees this and decides to check "thyme" also. So he does and then clicks the submit button. The problem is that now the record displays only thyme as the checked item. The second user replaced the items that the first user checked instead of augmenting them. How can I fix this in either the Connection Assistant, FileMaker, or in the HTML files? (If you do have an answer for me, can you super-dumb it down for a very new user? -)
Create an account or sign in to comment