How to edit a field when it uses a cartesian query as part of the record source?

[securitywyrm]

My situation is as follows



I'm building a contacts database and I have three tables
Table 1: Programs, currently 4 data points
Table 2: Contact titles, currently 3 data points
Table 3: MainData: Has Program key field, Contact title key field, and Contact Name data. Currently has three data points.

So I needed a form to show all possible combinations of program and contact title, which should be 12 (4 x 3). To accomplish this, I created a Cartesian query, which gives all 12 combinations:

And then made a form that uses that Cartesian query and the main data table, linking both the IDs...


And the result a form that looks exactly like I want it to:
which shows the 3 data points I do have, and the 9 that I don't.

HOWEVER, I can't edit the contact in this form! What change do I need to make to still have the 12 entries in the form, but have "Contact" edit/create the relevant entry in the main data table?

Note: Ignore attached file, I clicked the wrong thing, and I can't remove an attachment apparently.

[June7]

Yes, you can remove attachment from post. What file should be ignored - the last image?

Cartesian queries (or query using a Cartesian query) are not editable. Period.

Open another form filtered to the desired record for editing.

[securitywyrm]

Yes, you can remove attachment from post. What file should be ignored - the last image?

Cartesian queries (or query using a Cartesian query) are not editable. Period.

Open another form filtered to the desired record for editing.

So there's no way to have both the blank spaces in the form and have it editable?

The way we did this in the last database was that it was a giant flat file with a column for each contact, which became a nightmare to edit when they wanted to change titles and program names. If I use the Cartesian query as a filter, will that work?

[June7]

If I use the Cartesian query as a filter, will that work?

I think that was implied in my suggestion.

DoCmd.OpenForm "Contacts", , , "ContactID=" & Me.ContactID

The real trick is figuring out what event to put code in.