Dynamic List/Menu values from table
Using DA wizard I have created insert, update, detail & results pages. On the insert/update pages I should have dynamic List/Menu fields that are populated from another database table.
I can easily enough manually add these fields but is it possible to change the DA created fields to allow the options from another table, which ever one is selected gets written to the table? To test I created a new recordset from TblContactType and built dynamic list from that, now just need to get this into the DA created form & db.
TblContactType has option1, option2, option3, option4
On the insert/update page the field called ContactType is like this
<div class="rowElem"><label>ContactType:</label><div class="formRight"><input type="text" name="ContactType" id="ContactType" value="" size="32" /></div><div class="fix"></div></div>
I would like this to become a list/menu holding options from TblContactType, then when a user selects Option 4 lets say this is stored in DB table?
Thanks for any advice offered.