Oct 23 2008, 02:20 PM
I have a database that all queries are built from linked tables.
one disadvantage to this is that weekly the information changes (ie add or remove a soldier) and that I can not add or name a key kield to any of the tables. can I have a table update query run ar start up to change a "working copy" of the table?
Oct 23 2008, 05:34 PM
can you explain what you mean by
and that I can not add or name a key kield to any of the tables
Oct 23 2008, 05:42 PM
Also, are the tables linked to the "Working Copy" of the table? Do the weekly updates come from the "Working Copy" or where do they originate?