>2 tables/queries in a query still updateable???

[lastout]

I think I'm really missing something fundamental here. I have a few tables that are just about as normalized as they can be. They are tblTenants, tblApartments, tblVoucherStatus, tblNotices, and tblDates. Each tenant has an apartment (they may move from one apartment to the other in this same bldg), each tenant has a rental assistance voucher of a certain status, each tenant receives notices on various issues on various dates. Okay, head spinning. Having broken out these things into separate tables, I need to bring them back together again, via a query, so that the user can enter/edit data in frmTenants. My problem is that I can't seem to find a way to get them all together and still have the query updatable. All the tables have relations set in the relationship window and referential integrity is enforced. Can anyone help me with where I am going wrong? My engine has stalled.

I can provide further detail if necessary.

 

[dhookom]

You don't need to combine them all in one query. The preferred method is to use forms with subforms. Use the subforms for the "many" side of your relationships.

In order for related tables in a query to be editable, you should make sure that all joins involve Primary and Foreign Keys.

Duane
MS Access MVP