I have a table I am importing from an excel file. This table will be deleted and reimported probably weekly/daily. I have created a second table that will have some of the other information. The first table has closed file information such as:
AllFiles_Table
RowID, Company, Closefilenumber, Year of retention, Proposed Destruction Date, Destruction Date, etc.
I have added a second table,
ApproveforDestruction Table,
ID, RowID, AprrovedforDestruction (Yes/No), User, Approval Date.
My plan was to try and create a query I can use for a form to have the fields from the first table and the ApprovedforDestruction visible in the form. Then allow the user to just select Yes/No on that column. However I found when creating the query I really can’t do that because it is going to be an append to the second table.(Second Table is currently empty) Some of the users will literally have thousands of these to edit yes/no, I am trying to make it as simple to do as possible. Right now, I have splitform I was hoping to just add the column (ApprovedforDesrtuction) and allow them to check the checkbox. When they do it would append the 2ndTable. Is there any way to accomplish this? Or how would you recommend setting this up?
I have quite a bit more to do after this but I am hoping I can use a method similar to this for the rest of the forms.
AllFiles_Table
RowID, Company, Closefilenumber, Year of retention, Proposed Destruction Date, Destruction Date, etc.
I have added a second table,
ApproveforDestruction Table,
ID, RowID, AprrovedforDestruction (Yes/No), User, Approval Date.
My plan was to try and create a query I can use for a form to have the fields from the first table and the ApprovedforDestruction visible in the form. Then allow the user to just select Yes/No on that column. However I found when creating the query I really can’t do that because it is going to be an append to the second table.(Second Table is currently empty) Some of the users will literally have thousands of these to edit yes/no, I am trying to make it as simple to do as possible. Right now, I have splitform I was hoping to just add the column (ApprovedforDesrtuction) and allow them to check the checkbox. When they do it would append the 2ndTable. Is there any way to accomplish this? Or how would you recommend setting this up?
I have quite a bit more to do after this but I am hoping I can use a method similar to this for the rest of the forms.