Help Creating Invoices

[Kimmie]

Hi All,

I have created a database to track magazine sales. There are six issues a year and a separate integrated marketing area for miscellaneous sales. I have created a separate contact table, print ad table, and IM table. Nothing has an absolute price, everyone is different depending on their member discounts and number of issues purchased at one time so I don't have a Price Item database. I have created the data entry in portals so i can carry history for multiple years. The problem is the invoicing. I need to be able to create an invoice per issue. I am stumped on how to do this pulling data from a portal or can it be done? I am self taught and flying by the seat of my pants so please bear with me. Do I need to create some sort of pricing table using base prices and add discounts where applicable? The prices change every year. I would appreciate any help. Thank you!

Kim