How do I transfer a record from one table to the next?
I have inventory in one table and a record of all products sold in another.
I would like to run a script transferring a record/product purchased to the table containing sold products once I change the field status from "in-stock" to "shipped."
Being new to FileMaker, I would ask that you respond in the simplest terms possible.
Thank you and I would greatly appreciate any help!