There is no field in the service table that contains the customer number. I created the service table to host just the services that the business offers
There is no field in the service table that contains the customer number. I created the service table to host just the services that the business offers
Would it help if I sent you the DB to physically look at?
yes it would. do you know how to publish it on here?
No...sorry to say...please could you help with that too?
ok firstly zip the database then click on "go advanced" and then click on "Manage attachments"
Look for the "add files" button and follow instructions from there
ok...give me a second
Hi
I hope that I did this correctly
got it!! I'll get back to you
Thank you so much...It is a bit of a bugger when you are as stupid as I am
LERATO.zip
The structure needs altering from where you were in my opinion.
I've made some alterations here.
The query actually runs from 4 tables and your database is a lot more normalised now
The report seems to produce the correct data
Let me know
LERATO1.zip
Trimmed down
Welcome to the forum!!
I think the link between customer and order tables should be customerid_pk to customerid_fk