I see 3 tables; tEmps, tCars, tRegister.
TCar could be keyed on TAG.
Tag, Make, Model,Color
tRegister would hold the dates,a sub table of tCar:
Tag, RegDate
in a continuous form that shows all cars, put a text box in the header. User will enter a car tag,the event will filter the list on that tag:
Code:
sub txtFind_afterupdate()
if IsNull(txtFind) then
Me.filterOn= false
else
Me.filter= "[tag]='" & txtFind & "'"
Me.filterOn = true
end if
end sub
select the record in the list. Add another button to edit the details and a subForm to add the dates.
this button would open this form via the click event:
Code:
sub button_click()
docmd.openForm "frmEditTag",,,"[tag]='" & me.tag & "'"
End sub