Add automatic number of records.

[frankbutcher]

Hi
Is it possible to add a set number of records to a table, based on a field in another table?

I have a table, tblGeneralDetails, with one of the fields being Size. If the value of Size was 5, can I add 5 records to another table (tblIDDetails)
Also, then to lock the number of records so no more can be added?

This is all done via forms.

Many thanks.

Frank.

 

[Pat Hartman]

You can use a query to append the rows based on another value. I wouldn't enter just empty records but if you had a table that described the "sizes", you could copy those and append them to the item table. I presume you are doing this to manage your inventory. You would then modify your forms to prevent the addition/deletion of records by changing the AllowAdditions and AllowDeletions properties to No.