Populating a query from two tables

[Peter Simpson]

Hey Andy49....I figured it out EVENTUALY

[Peter Simpson]

Damn Andy49...I have no idea what I am doing wrong. I go the order query to work with the data that was in the order table. When I added a new row of data to the order table it does not pull through into the order query....Why? What am I doing WRONG?

Order Table


order Query Datasheet


order query design

[andy49]

Peter the new order you added has no serviceid_fk value. Should it have one

[Peter Simpson]

Yes it should. I am battling with the form to populate the table

[Peter Simpson]

I have been struggling for 3 hours now. Please help. How do I get ServiceID_Fk and CustomerID_Fk to populate on the form based on a selection from the combobox Service and then have it populate the arpsOrderTbl?



Order Table

[andy49]

Ok can you upload a database please?

[Peter Simpson]

OK thanks, but I really need to learn how to do this and not have to run to you all the time

[Peter Simpson]

Ok I have sent it to you

[andy49]

Peter have a look at subforms. I’ll see if I can find a link which may be useful. Anyone out there know of one?

Edit
https://support.office.com/en-gb/art...a-1e74d6f5f06b

[Peter Simpson]

I am so sorry Andy, but that still does not make sense to me

[andy49]

LERATO1.zip

Hi peter

Have a look at this.

The main form is your customer form and the sub form is your Orders for each customer

[Peter Simpson]

Here is the relationship attempt between arpsOrderTbl and arpsFeedbackTbl

[Peter Simpson]

Is this better?

[andy49]

Better yes. But I'd like my fellow forum users opinion on whether the link between feedback and customerID should be there. My personal thoughts are no.

Once we've sorted that Peter may I suggest a new post for the next problem. You're more likely to get "immediate" help and this particular thread is getting a bit long.

[andy49]

LERATO1.1.zip

Does this help with your feedback form Peter?