Move Data to another Table once active
I am new to filemaker and I am currently adding a feature to our current database, and I am not sure of the best way to transfer data to another table. What I am looking to do is add a referral tab onto a customer record (and store info in a referral table) and if a referral becomes a customer I would like to transfer that information into the customer database. I have been reading about ways of doing this and a lookup seems to me to be the way to do it however I am not sure this is the best way. Has anybody any ideas on the best way to do this, I am aware that swapping records between tables is not great practice but I cannot think of a better way.