H
Howard Brody
When I have a form that uses data from multiple tables, I
don't bind it to any of them. I put criteria controls
where the user can select what they want to see and then I
use luukups to populate the rest of the data.
For example, the user selects the Employee from a ComboBox
and clicks the 'display data CommandButton. Via queries
and DLookUps, I pull the employee data from the various
tables (PermanentData, EmergencyContact, TruckHistory,
Insurance, etc) and fill in the form controls. If there is
an update, I simply run updates off the form.
It may not be as fast to set up as a single query (as the
data source) but it does work well, with fewer relational
problems.
Hope this helps!
Howard Brody
don't bind it to any of them. I put criteria controls
where the user can select what they want to see and then I
use luukups to populate the rest of the data.
For example, the user selects the Employee from a ComboBox
and clicks the 'display data CommandButton. Via queries
and DLookUps, I pull the employee data from the various
tables (PermanentData, EmergencyContact, TruckHistory,
Insurance, etc) and fill in the form controls. If there is
an update, I simply run updates off the form.
It may not be as fast to set up as a single query (as the
data source) but it does work well, with fewer relational
problems.
Hope this helps!
Howard Brody