Copy files from one table to another with push of a button ?
I am trying to create a database for tracking a hobby.
I have one table which is a catalog of all available items and then if they are in my own personal collection etc.
I also buy and sell additional pieces to fund the hobby. Trying to keep track of what I buy and sell and at what prices. Is there an easy way from my catalog table to have select items copied into my purchases inventory and selling tables ? My thought is to have a button from my layout view of the catalog, that then adds that info into my purchase table and then I can add price and date purchased etc...
thoughts on an easy way to accomplish this ?