Button in the form of a specific record migrates to another table

[azhar2006]

Hello all
I have a table that contains a specific type of data Synthetics
I want to put a button on the form of a specific record migrates to another table


I also want to add another button to re-record it to the main table
Is it possible and how?
Any help from you or Example
Thank you ...

[AlexHedley]

So you want to move a record from one table to another and vice versa?

Do both Tables have the same Fields?

Do you have an example?

[June7]

Why do you want to move records? Why not just change the value in a 'Status' field and filter records?

[azhar2006]

Thank you Alex Hedley
Ok

[azhar2006]

This is an example
Yes will explain to you
There are products I want and when I want to migrate withdrawn again do I recover them for the main table
So skip the deletion

[June7]

A db with 1 empty table doesn't explain much.

Your issue is resolved?

[azhar2006]

This is another example

[June7]

Now the 1 table has records. That still doesn't answer the question of 'Why do you want to do this'. Nor does it address the suggestion given for a 'Status' field.

[azhar2006]

You know that silver ounce sold
In terms of price changes ounce In this case, I want the next
Silver, for example, that I bought about a month ago at a price of $ 1000
Today I bought silver at a price of $ 800
I want to sell before the new silver old silver
So do not sell customer Adilm
I also do not lose in the old silver
Since the date of purchase of the modern silver material is sold first, and when the force
Is to shift old stock or other carry-over to the table
.

[June7]

What you are really talking about is inventory tracking/valuation and calculating profit/loss for a period using FIFO (First In First Out) method.

Conventional approach is a table of transaction records for purchases and a table of transaction records for sales. Another table of products with current pricing info. It is the product/pricing table that would be adjusted. It is from this table that price info will be selected for the sales transaction record.

If you bought silver at $1000, what will be your selling price for silver in Products table? Sell silver at that price until the $1000 quantity is gone then adjust sale price in the Products record for silver, if you want to, for the $800 silver remaining in inventory.

This link discussess calculating product balance on hand but does not calculate inventory value http://allenbrowne.com/AppInventory.html

Calculating product inventory balances based on FIFO method is probably complicated, something I have never done.

Otherwise, use a 'Status' (active/inactive) field to filter records instead of moving them back and forth, much simpler.

[azhar2006]

OK
Look at this example
Look how the tables in the database
If I want to practice what I found in this example
But the problem is how I re-record

[June7]

Table_1_Inactive makes some sense along with frmFilterByStatus. This is in line with my suggestion for a 'Status' field.

The only code I see for moving records is moving to Table_2_Delete from Table_1.

Moving and deleting records indicates poor design. Rarely justification for deleting records.

But if you really must, then adapt the code to do the movement you want.

[orange]

There is an example of FIFO in response to another poster several months ago at
https://www.accessforums.net/access/fifo-inventory-25249.html#14


I had to reinstall acc2003 to open the modules and to see all the tables.
I could not get this iinfo to show when using Acc2010. If anyone knows how to open the database
and show the module and database window and tables in Acc2010, please advise - or attach the modified database.
Thanks.