chris_brown Posted April 21, 2004 Share Posted April 21, 2004 Hi, I have a database where I would like to select data from a list box, the data in the list box is Small Medium and Large. When I select small I would like the db to auto enter the number 1 into another field. When I select Medium I would like it to auto enter 2 in the field. How is this done? Thanks for any help Chris. FileMaker Version: 7 Platform: Windows XP Link to comment Share on other sites More sharing options...
Reed Posted April 21, 2004 Share Posted April 21, 2004 You could set the auto-enter option for the number field to "by calculation" then use an if or a case statement to make the result dependent upon the other field. Dana Link to comment Share on other sites More sharing options...
Newbies Doctor Flash Posted April 26, 2004 Newbies Share Posted April 26, 2004 Or simply define the "number" field as a calculated field using the same calculation Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7303 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now