kevind
Posts: 251
|
| Posted: 09/21/2005, 2:57 PM |
|
- i have an editable grid - grid A
- i only allow 1 row for inserting new records
- col 1 is a lookup (listbox) col 3 is a y/n value
- there is a drop list for col 1 that references a table B and then inserts the ID value into col 1 of table A (grid A)
- before the row is inserted in grid A I need the grid to lookup the y/n value in a col in Table B and set the value of col 3 of Table A to that value
- i used a dlookup to get the value and store it to a session variable, then used the custom insert function under the data tab to insert from that session value into the col
- I could have SWORN I saw it work once but, then I got all smart-ass and renamed my 'test' session variable names to something more useful and it stopped working (i've checked they match so it's not a typo)
Can someone tell me if my approach is even do-able. Whenever possible I like to avoid fancy code and get CCS to do the leg work through its built in functions.
thanks,
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
 |
 |
kevind
Posts: 251
|
| Posted: 09/21/2005, 5:11 PM |
|
never mind - i figured it out, just put the dlookup expression into the custom insert settings as an expression, dropping the CBool( ) part of the expression to make it work.
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
|
