User Profile
hedwards400
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Primary key sequence defined by selections from a Lookup Table
I’m trying to use information in a field to set a number sequence for my primary key field. For example, I have a dropdown lookup with the following word choices One, Two, Three in field b. If I choose One in field b, I want field a (my primary key) to display a number sequence starting with 10000. If I choose two in field b, then I want field a to display a number sequence starting with 20000, and so on. So if I choose One in field b for two different records, then my primary key should be 10000 for the first record and 10001 for the second. Any suggestions how to make this happen?743Views0likes2Comments
Recent Blog Articles
No content to show