By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

hatchback cars

P: 3
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
Attached Images
File Type: jpg JaDu1.jpg (54.4 KB, 138 views)
File Type: jpg LcOwX.jpg (41.8 KB, 43 views)
Mar 15 '17 #1

✓ answered by 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

Share this Question
Share on Google+
4 Replies


PhilOfWalton
Expert 100+
P: 1,430
Please show an image of your relationships with tables showing full length so that all the fields can be seen

Phil
Mar 15 '17 #2

P: 3
Here's my relationship table between CAR and SERVCIE
Attached Images
File Type: jpg Capture.jpg (22.4 KB, 40 views)
Mar 19 '17 #3

PhilOfWalton
Expert 100+
P: 1,430
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
Mar 19 '17 #4

P: 3
It's random data only. Thanks for the help
Mar 20 '17 #5

Post your reply

Sign in to post your reply or Sign up for a free account.