Hi I have a scenario here. Here is everything:

The story is an auto repair shop that needs to keep track of customer records, car records, and job records.
All records needs to be displayed on the one form (THE MAIN FORM).

On the MAIN form, it will need to have the following:

Customer detail (subform)
Combo Box (Car Tagno.)
Job Card detail (subform)

Criteria:
Selecting the car tagno. from combo box will pull up the particular CAR info, which the CAR info links up to its CUSTOMER detail.
Also, there are multiple dates to which JOBs that done on that particular TAGNO. so the JOB DATE will have to be in a list box or combo box.

Once the JOB DATE is selected, then the JOB CARD DETAIL gets displayed.


in short I've drawn a diagram:

Click image for larger version. 

Name:	untitled.JPG 
Views:	58 
Size:	41.1 KB 
ID:	11040

Those subforms can be on one subform together or can be separate.

I don't know how to go about doing this.



I have the data in tables in ACCESS, but QUERY = NONE

Please help, i can provide more info if asked



WORRIED