AnsweredAssumed Answered

Non serial number primary key

Question asked by LuisHernandez on Jul 29, 2015
Latest reply on Jul 29, 2015 by philmodjunk


Non serial number primary key


Version: Filemaker pro 12

I would like to use auto fill in drop down value lists in my database, but I see that this is not possible if I use an auto enter serial number and then use "show second value". I have reviewed the work arounds provided by PhilModJunk (thanks a lot by the way), which work well. However, I wonder if there is any reason to not remove the auto enter serial number primary key and simply use the values associated with them. The values I want to use are state names and codes and country names and codes. For example:

With serial number:

#     Name        Code

1     Virginia      VA

2     California   CA

Without serial number:

Name         Code

Virginia        VA

California     CA