Updating data in row copies to all rows

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have a query that uses 2 tables, Employees & Courses
that has a one-to-many relationship.

I run the query and update data in a row. When I move
out of the row I've just updated, all of the data in that
row is copied to all other rows.

Any idea what I'm doing wrong? Thanks much
 
Alex

Could you provide a bit more information about your data structure?

How do you confirm that "all the data in that row is copied to all other
rows"? By query? By inspecting the table directly? Which table(s)?
 

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

Excel Help to copy information from one row at a time to another sheet 1
update next row 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Aligning beyond "Joining" in query--forcing blank rows to appear 11
Update Query and Too Many Rows 4
Excel Moving data to sheet2 from sheet1 0
Append Query Issue 0
Stacking Date/Time from Row to Row 3

Back
Top