Sorry for the very open and vague question guys.
I am making my way across from MS Access, so am pretty aware of the structure I need for my setup, but am struggling to implement what I need.
Essentially I am running 3 tables in a parent>child setup as follows: “Client>Invoice>components” Obviously the first two are straight forward, the components table holds activity booking information, notes, start times and such.
I have tried the idea of grouping based on invoice and client(this would be satisfactory), it works fine with invoice, but can’t filter by client as referencing a client control through the invoice table means that I can not then create new components.
I am looking for a way whereby I can have a table view on components somehow controlled by a selection in invoice, and was hoping someone out there may be able to point me in a direction. Maybe auto filling the invoice control on the components table is a possibility? Just throwing a starting block out there.
I hope this all makes sense. I’ve attached a image of the access database I have been using as a visual aid. Sorry it’s not the best explanation.