The Wizard only seems to allow me to add one table driving a subform, but I want to track several.
I’m trying to normalise everything so almost any informative form needs data from 4 tables.
I’m tracking support issues. I have tables (1) Issues - each row is an issue summary (2) Complaints - some issues become complaints with other information necessary (3) Updates, describing what has been done each time something is done. An update can affect several issues and this informaiton is capturesd in (4) IssuesAffectedByUpdate, where each record is a couplding of an Update ID and an IssueID. (3) PossibleIssueStatusValues drives a drop-down of statuses, and simplarly for PossibleComplaintStatusValues.
So I want one form drien by Updates. I scroll through the updates and add new ones. For each update record, the form pulls in the complaint data, if any, and the issue data. This requires the intermediate table IssuesAffectedByUpdate to link Updates to Issues. I haven;t worked out how to represent multiple issues on the form for updates which affect more than one.
But so far, I can’t get pasty not being able to dd more than one table to the subform.
Any help would be appreciated.
Thanks