hatchback cars

[Doc15]

I need to display query of requested Honda "hatchback" car such as Car Registration number, and the number of times the car has come for servicing.

Thanks for the help

[PhilOfWalton]

Please show an image of your relationships with tables showing full length so that all the fields can be seen

Phil

[Doc15]

Here's my relationship table between CAR and SERVCIE

[PhilOfWalton]

Relationships look fine
I have a slight concern that not knowing where you live and the format of car registrations in your country, there is the possibility of entering the same car registration with and without a space.
e.g. AB08 LXY and AB08LKY. This would appear as 2 separate cars.

If this is a problem, I would use a CarID as the key in the Car Table and the Foreign key in the Service table. Then, when you enter a car number, it can be converted to upper case and no spaces.

I digress.

To answer your problem, build a main form based on cars and customers and a continuous subform based on service details and employees. The LinkMasterField would both be CarID (or the LinkMasterField would be carRegoNo & the LinkChildField would be CarRegistrationNo)

That way you get a full service history for the car.

Phil

[Doc15]

It's random data only. Thanks for the help