AnsweredAssumed Answered

Replicating Unique Field data from one FMP table to another

Question asked by MichaelWeisenberg on May 19, 2012
Latest reply on May 21, 2012 by Sorbsbuster

Title

Replicating Unique Field data from one FMP table to another

Post

HI

I am a newbie attempting to develop an educational database in FMP 12 to use as a college gradebook. To link my tables, I am using a unique student ID field (issued by the colllege so it cannot be serialized) as my primary key. Since I have entered this unique Student ID into one of my tables, which is linked to other tables using this field, to save time, I am wondering whether FMP offers an easy way to replicate this student ID data from one table to another. Apparently, I may not be able to use the lookup table to auto enter this data as the unique Student ID is issued by the college and is not serialized. I come to FMP having previously used Microsoft Access where I was used to using an append query to accomplish my goal. I am unsure how to do this in FMP or even if it is possible to do so. I would appreciate any feedbak from others who may have done this before me. Thanks.

Outcomes