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.
- Thank you so much and my apologies for the late reply. I'll provide screen shots of what I'm talking about once see if the alternate solution works for what I need. Thank you again so much. Best Regards, Tony.
