AnsweredAssumed Answered

Non serial number primary key

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

Title

Non serial number primary key

Post

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

Outcomes