Client and car form (mechanic database)

[faca]

Hello!

I would like to ask what would be the best way (how to do it) to display client and his/her cars in same form? Currently i have list of clients in one form and list of cars in other form.

Tables ->

Client:

ClientID
FirstName
LastName
Address
City
Country
MobileNumber
Email

Car:
CarID
ClientID
Make
Model
Year
Transmission
Fuel
LicensePlate
VIN




Thanks

[June7]

Use form/subform arrangement. Or build a report.

[Micron]

Agreed. Your table structure doesn't allow for any history though. The way you have it, there is no field to archive a vehicle and I'd suspect wherever you do business, the law would require you retain information for a set period of time. If not, you should, just to CYA. Likely you don't care to keep historical plate numbers, but just in case - you can't do that either.
From an ex meck-u-nick

[faca]

Agreed. Your table structure doesn't allow for any history though. The way you have it, there is no field to archive a vehicle and I'd suspect wherever you do business, the law would require you retain information for a set period of time. If not, you should, just to CYA. Likely you don't care to keep historical plate numbers, but just in case - you can't do that either.
From an ex meck-u-nick

This database was made for my friend and it is strictly made for private use.. he asked me if i can make him program beacuse he was using book (in his book were list of clients, cars and all services he done all written by himself).

Problem was that book was full really fast and for example if he needed to know what he did to client's car 4 months ago it took him 10-15 minutes to find that note. Now with access this is a lot easier...

[June7]

You need another table for Services if you want historical records.

[faca]

You need another table for Services if you want historical records.

Yes, i have that. I was just asking what would be the best way to list clients and cars in same form.

What i have now is:

One continuous form where all the clients are listed and one continuous form where all cars are listed but i would like to have both in same form.



For example i'll search for client and click button cars and ill get popup or something too see which cars belong to this client.

[June7]

A main form in Single view for clients and subform in Continuous or Datasheet for cars. Or review http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp