Hi, a simple question and as usual there are likely several ways around it. What do you think is best?
(1) My current aim is to offer an additional checkbox on an Add page. If the user ticks it, then on saving, various other actions will happen (e.g. auto populate some sub-table records with defaults linked to the record just added etc).
How would you do this? Adding a field to the SELECT statement, e.g. "0 As chkboxDefaults"? Are there side-effects with this? (i.e. will the INSERT statement still work?)
In practise I see me having loads of such situations in the application I am planning.
(2) If I didn't want to do it in the SELECT statement, like (1), an I easily drop a text box and label in the Add page table? So far I have found adding rows to these tables tedious, as the formatting seems very cumbersome to get right ...
Any views on this?
Ideally it'd be like any visual editor (Visual Studio, MS Access etc) and I could just pick a checkbox from a toolbox or something* ...
Thanks a lot for your help.
Matt
____
- Apologies if there is a way to do this - but I had a good search and can't see it clearly laid out. I would have expected this in the user guide as it's surely one of the most common requirements around.