Hi all,
I am looking for some advice if possible on a project management database.
I am currently speccing this out at the moment and getting some tables built. My big issue comes when I get to billing and invoicing.
To give you a headsup, the company I am building this for does well site analysis on oil rigs. When they do a project, the project can (and often does) have more than one well. When it comes to invoicing and billing, i need to have something in place when the invoice covers all of the wells in the project.
I have already created a well table and linked that to my projects table. However, do any of you have any idea how I could amalagamate any wells selected into one billing/invoice?
Thanks!
I am looking for some advice if possible on a project management database.
I am currently speccing this out at the moment and getting some tables built. My big issue comes when I get to billing and invoicing.
To give you a headsup, the company I am building this for does well site analysis on oil rigs. When they do a project, the project can (and often does) have more than one well. When it comes to invoicing and billing, i need to have something in place when the invoice covers all of the wells in the project.
I have already created a well table and linked that to my projects table. However, do any of you have any idea how I could amalagamate any wells selected into one billing/invoice?
Thanks!