P
pjdavidson
Guest
I'd like to automate the update steps below. I get stuck trying to copy the the structure ONLY of the table. Suggestions?
Update the applications unique table
• Run “create applications table” query
• Copy the applications table
• Paste applications table
o Structure Only
o Rename as applications unique
• Open applications unique in design view
• Make Comp_Inv_ID the primary key
• Make the Company field indexed – Duplicates OK
• Save; close
• Run “delete dups application table” query
Update the applications unique table
• Run “create applications table” query
• Copy the applications table
• Paste applications table
o Structure Only
o Rename as applications unique
• Open applications unique in design view
• Make Comp_Inv_ID the primary key
• Make the Company field indexed – Duplicates OK
• Save; close
• Run “delete dups application table” query