nubianqueen
Technical User
I have a table called Policy Titles.The user wants to delete a title when it's no longer in use, so the title number can be reused.As the designer I feel no record should be deleted but just made inactive. There is still the issue of reusing the title numbers.
I thought I could use a make-table query to move inactive titles, but found out that each time the query is run it will wirte over existing records.
Is there some other way to handle this issue or am I going about it all wrong?
Any help or suggestions would be great.
Thanks
nubianqueen
I thought I could use a make-table query to move inactive titles, but found out that each time the query is run it will wirte over existing records.
Is there some other way to handle this issue or am I going about it all wrong?
Any help or suggestions would be great.
Thanks
nubianqueen