Left Join query + form--updateable?

[Amy Blankenship]

Hello, all;

I want to have a form that shows all possible options, even before there are
records that match those options. So I want to have a query with a left
outer join on the "Options" table and the junction table between "Scenarios"
and "Options."

Before I spend a lot of time building forms based on the idea that this will
work...will this query be updateable? If the section of the help that deals
with this mentions this specific type of query, I was too thick to make the
leap.

Thanks;

Amy

 

[Steve Schapel]

Amy,

You can check this out yourself, just by making the query in question in
the query designer, then run it to get the query datasheet, and see if
it's got a blank row at the bottom, or if you can edit or enter data. I
don't quite know exactly what you mean without more details, but my
guess would be Yes, it will be updateable, as long as the field in the
Options table that you are joining on is a unique index.