Maybe I really need something like macros and BASIC or Python to make such a thing work? If anyone knows a good tutorial on this subject, I can certainly read - just haven't really found anything yet.
Thanks Josh, that helps a little. I get the impression from Drew's discussion that it is possible to choose between creating stored procedures in LO Basic and the PGSQL native procedures. Is that correct? He gives no examples of how to use the MySQL triggers/procedures, so I am not sure how to ensure that, as I enter my data in the form in Base, it gets "held" until I am ready to hit "submit".
I know very little of LO/OO Basic - or of stored procedures, for that matter. So it looks like I've got a bit of reading to do.