i need a easy to use db program to track
royalty payments
i like excel
but will consider other things
the program needs to feed information from a static page into forms
and from the forms generate totals
static info includes these facts:
for the author
real name
pen name
agreement on file
address
paypal
bio
storylist
precent royalty
+++
for the narrator
real name
pen name
agreement on file
address
paypal
bio
storylist < must be expandable – in that an author may have 30 or more titles
precent royalty
+++
for the artist
real name
pen name
agreement on file
address
paypal
bio
storylist < must be expandable – in that an artist may have be assigned to 30 or more titles
precent royalty
for other publishing houses
real name
pen name
agreement on file
address
paypal
bio
storylist< publishers can submit up to 200 stories
precent royalty
this info will feed into
will be:
+++
sku# story author ebook print narrator genre length pricing artist story description excerpt date added to store percent to author percent to narrator percent to artist hosting mailing PureO
this in return
should then allow me a separate page that i enter the monthly SKU# and it generates
author percents
narrator percents
artists percents
publishinghouse percent
PureO percent
price
title
that may be a little wanky and you may see a better way to handle this – i am open to suggestions as long as it is easy to use.
