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:
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