Newbies Bscott Posted January 26, 2005 Newbies Share Posted January 26, 2005 I have a little newsletter and sell advertising to supplement the cost. The cost buy an ad depends on the size of the ad and the amount of subscribers. For instance RateCard A is for 1000 subscribers. A 2/3 ad would cost you 50.00. Now if subscription rises, I would create a new rate card called RateCard B. What I would like to do, if possible, is create a DB that contains two value lists and returns the current rate for the publication. The two value lists would be AdSize and RateCard. Right now in the AdClientOrder, I can choose 2/3 and it will show the current price. How do I also ad a value list that if RateCard B is chosen, the price will increase? I just have two DB's right now...AdClientOrder and RateSpecs. I also have a third DB called RateCard, which contains all of the rates for the sizes. Would it be best to just ad a portal on the AdClientOrder and call the info that way? I guess it would be easier to manually enter everything, but the RateSpecs also contains other info used in the issue DB. Thanks Link to comment Share on other sites More sharing options...
This topic is 6625 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