I have a pair of dynamically created valuelist that are loaded via SQL calls. One is a type-ahead valuelist that lets the user enter a clients name which is based on an SQL Query so I can do some concatenation . that seems to work fine but what needs to happen is once that person is selected, my second valuelist, which is the next form item, needs to then run my sql query to grab the addresses for that client. basically we have two tables, a people and an addresses table because one person can have more than one address. What i want is for that second valuelist to display only the addresses for that client… which works.. kind of. basically, once i select that second valuelist, select an option, and that option is then displayed in that combo box… however, and here’s my issue (sorry for the long background about my form but…)
This form is in List View… so if i go to the next record and enter another name, the previous records valuelist item gets updated to something from the new set of addresses for my new record. so its almost like its saving the id for that valuelist but its updating every valuelist on the list view form when i update one record. is there any way to just update the valuelist for the current record im on, and not mess up the other records addresses valuelists? or could i just be doing this entirely wrong?
thanks in advance for any feedback.
