I have created this great chemical inventory database...now I want to put it on the web to allow my people to update their inventory by internet.
I am using HTML & CDML along with Custom Web Publishing to try to get my database on the web.
I am having problems with creating the pages to allow adding a record to the database. My problem is that I want to use conditional value lists that I have in FM Pro, but is there a way to recognize a value inputted in one field, to choice the correct value list for another field....without submitting the new record to the database? or do I have to submit, than use an edit form?
The other problem I have is that for one of my fields, I want to use a value list that allows you to enter a different value than those listed in the value list. Can I do this? DO I need two fields....one that is a popup menu that they can select from if they want (field 1) and another that they can enter their own values (field 2).....if so how do I get the correct value submitted into the database...is a script and another field needed (field 3)...
such as :
if field 1 = "no selection"
set field 3 = field 2
else field 3 = field 1
Am I missing a key point to understanding how to accomplish these?
