Add or Edit data in a Multi-Table Query?

[Buckster]

I had a large table with 60+ Boolean fields in it (Yes/No). To make it web-ready, I had to reduce that number to <30 per table, so I separated the table into multiple tables of info.

I'm looking for a way to keep the input form that used to access and write to this single table intact because of a user interface issue.

I thought I might be able to knit the data back together in a select query, and then redirect the associated form to it, but because of the multiple tables involved in the query, it's stopping me dead in my tracks from being able to update or add new records.

Is there a way to pull this off?

 

[bparkinson]

Probably, the query does not include the primary key for both tables. It needs to be present for the query to be updateable.

 

[Buckster]

Probably, the query does not include the primary key for both tables. It needs to be present for the query to be updateable.

Fantastic! Thanks so much!