Populating a query from two tables

[Peter Simpson]

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

[Peter Simpson]

Tables

[Peter Simpson]

Would it help if I sent you the DB to physically look at?

[andy49]

yes it would. do you know how to publish it on here?

[Peter Simpson]

No...sorry to say...please could you help with that too?

[andy49]

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

[Peter Simpson]

ok...give me a second

[Peter Simpson]

Hi

I hope that I did this correctly

[andy49]

got it!! I'll get back to you

[Peter Simpson]

Thank you so much...It is a bit of a bugger when you are as stupid as I am

[andy49]

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

[andy49]

LERATO1.zip

Trimmed down

Welcome to the forum!!

[Peter Simpson]

Hi Andy49

Query SQL



Query Design



Query Datasheet

[andy49]

I think the link between customer and order tables should be customerid_pk to customerid_fk

[Peter Simpson]

Hi Andy

I have made the relationship change but still no population of the query.



I am so sorry for pestering you like this