Hi, I'm new to filemaker (12) and databases in general but here's what I'd like to do.
I have a master list of available paintings with fields for sizes, descriptions, etc.
I would like to have a record move to another table (sold paintings) and be removed from the parent table when the user clicks on a checkbox named SOLD.
The list of sold paintings would be useful for reference.
Is there a simple way to do this?
Thanks for any help!