AbsoluteVoice4u Posted February 22, 2005 Share Posted February 22, 2005 I'm working with a rather large database with many fields. My "price guide" field will contain either the letter A or B. If "A" is in the "price guide" field then the following will be true for that record: starter price = $1,000 maintain price = $1500 If "B is in the "price guide" field then the following will be true for thet record: starter price = $1,250 maintain price = $1,750 The "price guide", "starter price" and the "maintain price" fields exist in all 23,000 records. At my discretion, I place either an A or a B in the "price guide" field. I want the two other fields in each record to populate automatically dependant upon the "price guide" field being either an A or a B... What is the proper way to do this.......scripting?....a relationship?...what?. Is it so simple I do not see it? Link to comment Share on other sites More sharing options...
This topic is 6601 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 account
Already have an account? Sign in here.Sign In Now