The "standard" SQL form for inserting rows involves writing all the column names and all the field contents or references, with the possibility of omitting the column names.
Several forms in my current app have a dozen or more fields, such as name street city postcode phone etc, that are displayed to the user for information and are also available for editing. A method of adding new records is needed, and the obvious way is using the same form. However I cannot find, after 2 days of searching help files and forums, a way of using the TIB_Edit fields already linked to a TIB_query to insert new rows. I am obviously keen to avoid the long-winded "standard" SQL method, given I have several forms to do. Could someone please explain how it can be done?
Regards
Robert Nixon