Can I make a Base form linking several tables using the Wizard?

[Xeno1]

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

[Villeroy]

No, the wizard is close to useless. It handles only one form with one sub-form. It never creates any list boxes on foreign keys.
Forms with one-to-many and many-to-many relations:
https://forum.openoffice.org/en/forum/download/file.php?id=11250&sid=360c0071647e4e52c99183b28ebc9ee0

[Xeno1]

Thanks for the comments and the link!

[skyandrews]

It sounds like the subForm’s underlying table (4) just needs to be a join type table having two primary key fields. The table wizard can not acheive this! After copying a backup of the odb, follow these instructions.

• Open the odb, then in the relationships tool, delete all relations to and from table 4. Save and close relationships! Save the odb!
• Edit table 4. Unmark the current field that is primary key (right click the left row marker with key icon, and deselect “Primary key”). The key icon should disappear. After saving the table (required), simultaneously select (ctrl+click) both of the desired primary key integer fields (like “update_id”, “issue_id”), then mark them as primary key (right click one of the row markers, select Primary key). Both row markers should now show the key icon. Save and close table 4! Save the odb!
• In the relationships tool again, recreate relations between the two primary keys of table 4 and their related table primary key fields (like “Updates.ID”, “Issues.ID”) You may want to set the relation’s update option to update cascade at this time. Otherwise, save and close relationships! Save the odb!
• Now the form/subform based on table 4 should allow you to create and save multiple links between Issues records and Updates records, blocking duplicates. Listbox controls of the form will need their Data field set to the corresponding pk field of table 4 (like update_id, issue_id), but the listbox content sql or table needs to be based on the corresponding Updates or Issues table.

[Xeno1]

Thanks for this clear and comprehensive response. Very kind.

Chris