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

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.