Can I edit data in a query with a one-to-many relationship (2000)

  • Thread starter Thread starter Saar
  • Start date Start date
S

Saar

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?
 
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?
Click to expand...

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query with one to many relationship 2
Creating a query with one to many all on one line 3
Query joins not created in front end query grid 2
Many-To-One Append Query 2
multiple one to many 2
Query on a set of optional M2M relationships 1
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
many to many relationships 9

Back
Top