AnsweredAssumed Answered

Move Record from one Table to Another Table

Question asked by bradduncan on Apr 26, 2017
Latest reply on Apr 26, 2017 by philmodjunk

Hey FM Community!


I think adding context to the question I'm asking would be helpful for the beginning!



I recently separated two tables, one for volunteers and one for applicants for a volunteer position. In these tables, we store details such as name, address, the usual user personal information. I know separating it might not make sense when a lot of the data will be the same, but it was more so to create a clear distinction between the two supposed to having  one table with both volunteers and applicants.



We are currently using FM Cloud, FMP and FMP Advanced 15.



I want to create a button that moves the record of an applicant to the volunteer table, whilst deleting the applicant record once transferred. The field names are all exactly the same. I'm really struggling with such a simple script and was hoping for a little bit of guidance! Apologies for asking such a rookie question! If you need any more context, please don't hesitate to ask!


Thank you in advance, and I hope you're having a great and productive day!!!