I don’t believe my requirement is all that complex, but I’m having difficulty understanding how to work out what relationships are need in order to build a suitable base.
I have multiple projects in progress. Each project is supplied by a selected list of suppliers, not every supplier on every project. I would like to track projects to the point where they complete, at which time I then invoice for commission. Some projects may have early quotes associated with them from each of their suppliers.
This seems like it should be a standard thing to be doing - common practice in my industry, so is there a template base that would immediately suit this requirement? Or do I have to build one from scratch?
Thanks very much for doing that. I have already got past those stages, by creating multiple tables. It is the linking of the tables that confuses me. Rather than try to describe what I am trying to achieve is it possible for you to see my account?