Report Creation

[haydencohen]

Hi, I'm creating an invoice system for an entertainment agency based on relationship tables and databases. I have a database for clients, performers and events. Within events, I have two tables. One for the event, and another for the invoice. What I want to do is for an invoice to be automatically generated when certain criteria are met. I think this may be a portal, but I want to include information from another database that isn't in the event form.

I hope that wasn't too confusing

Thanks for your help

Hayden

[Brian C]

Could you be more specific as to how your clients and performers data is going to be connected to the events and/or invoices?

It would be helpful if you could provide us with an example of what you would input where and what would happen.