AnsweredAssumed Answered

Move Data to another Table once active

Question asked by MikeJackson on Oct 4, 2011
Latest reply on Oct 5, 2011 by philmodjunk


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.