Hey Andy49....I figured it out EVENTUALY
Hey Andy49....I figured it out EVENTUALY
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
Peter the new order you added has no serviceid_fk value. Should it have one
Yes it should. I am battling with the form to populate the table
Ok can you upload a database please?
OK thanks, but I really need to learn how to do this and not have to run to you all the time
Ok I have sent it to you
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
I am so sorry Andy, but that still does not make sense to me
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
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.
LERATO1.1.zip
Does this help with your feedback form Peter?