S
sham_on_air
Hi
i'm trying to make vehicle database.the purpose is to keep track of the
vehicles which is used by different departments.
i have two tables, customer [ Id(pk),Name,Title,Dept..etc] and vehicle
[ regno,make,model,color...etc and id from customer table for linking (one to
many relationhsip) ].
i've also made query combining both the tables and based on that query i've
made a form.
on the form, fields from vehicle table is attached as a subform.i want to
autofill vehicle details if the vehcle is already entered.
please help me to do this..
regards
i'm trying to make vehicle database.the purpose is to keep track of the
vehicles which is used by different departments.
i have two tables, customer [ Id(pk),Name,Title,Dept..etc] and vehicle
[ regno,make,model,color...etc and id from customer table for linking (one to
many relationhsip) ].
i've also made query combining both the tables and based on that query i've
made a form.
on the form, fields from vehicle table is attached as a subform.i want to
autofill vehicle details if the vehcle is already entered.
please help me to do this..
regards