one Price for first item, another price after that...

[santinimatias]

I cannot figure out hot to approach this problem.


We charge two prices when we burn a CD with information for a client: $20 for the first copy, and $5 to all additional copies.
I used just a simple combobox that shows both ist copy & Add'l copies, with a textbox next to it. If the use selects the 1st copy, then an "1" would be added to the textbox. then you save the record. A second record would be needed for the additional copies.
We are not happy with this, but I cannot figure out how can I have both the 1st copy and the add'l copies in the same record, or how to do the costs calculations. I tought of using a many to many relations, but I can't make it work. To add to the cake, the price on the copies changes over time, so there's need to be a timestamp and status (current, archived) fields.

Any suggestions on how to approach this?

Thanks!


Windows 8, access 2013.

[orange]

TotalCost = 20 + (5 * HowManyCopies)

All you need to know is How Many Copies were made for the Customer.

[santinimatias]

Sorry, I guess I wasn't clear. And I found a work around.
Thanks you for the response!

[orange]

For others who read this later, it would be useful if you would (for completeness):
-clarify the original requirement
-post your solution

Good luck with your project.