How exactly the recordsets work

[crystalized]

I am trying to figure out exactly how the recordset objects work (DTC's).<br>If I make the recordset based on a table.<br>I base the form elements on the recordset.<br>I allow the user to enter data into the form elements.<br><br>Does the data entered by the user go directly into the table I based the recordset on.&nbsp;&nbsp;<br>If this is the case, how can I provide a value for a column in the table, that is not entered by the user (ie ID field).&nbsp;&nbsp;Do I place a textfield (or other element) in the form, hide it, and set a value.&nbsp;&nbsp;Also how do I check that all the required fields are filled before I allow the data to be entered into the table.<br><br>If this is not the case what do I do to enter the data inside the elements as a record in the table.&nbsp;&nbsp;I have been looking through the book I have and have not found a satisfactory answer.&nbsp;&nbsp;<br><br>Should I use a stored procedure instead of the recordset being based on the table, if the only thing I want to do is insert records.<br><br>I guess in the end I am very unsure of how the recordset DTC's work for data entry (inserting records).<br><br>Thanks in advance for any advice anyone can offer. <p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>