I'm having a query which is based on two tables with a one-to-many
relationship. On this moment that somehow makes the query unediteble, how can
i change that?
Be sure that the link is from the Primary Key of the "one" side table (or at
any rate a field with a unique Index), and that a Relationship is defined
between the two tables.
Generally it's better NOT to do it this way - for one thing, each record in
the "one" side table will be displayed repeatedly if there are multiple "many"
side records, or not displayed at all if there are none. Consider instead
using a Form for the "one" side table and a Subform for the "many".