Forum Discussion
New to access trying to print a car's specific info to a form and report
Access provides a really good mechanism for requirements of this sort.
Use a main form/sub form design.
The main form is bound to the Customer table.
The sub form embedded in that main form is bound to the automobile table.
The subform control (in which the automobile form is embedded) has a property that controls which records from the automobile table appear in the subform, the
Master Linking FieldLink Master Fields and theChild Linking FieldLink Child Fields properties. This means that the automobiles displayed in the subform will be only those where the CustomerID is the same as the CustomerID for the currently selected record in the main form.Because the subform can be displayed in Continuous view, ALL of the current customer's vehicles are displayed in full and you can select the one you want.
A similar mechanism is available for reports/subreports.
Access provides a really good mechanism for requirements of this sort.
Use a main form/sub form design.
The main form is bound to the Customer table.
The sub form embedded in that main form is bound to the automobile table.
The subform control (in which the automobile form is embedded) has a property that controls which records from the automobile table appear in the subform, the Master Linking Field Link Master Fields and the Child Linking Field Link Child Fields properties. This means that the automobiles displayed in the subform will be only those where the CustomerID is the same as the CustomerID for the currently selected record in the main form.
Because the subform can be displayed in Continuous view, ALL of the current customer's vehicles are displayed in full and you can select the one you want.
A similar mechanism is available for reports/subreports.
George_Hepworth Thank you so much sir, the idea of adding a continuous form as a subform works perfectly. Thank you very much I'm very happy.