Updating via queries

[Rick]

I have a file that contains multiple duplicate records except that they have
a unique key.

i.e. multiple row number /seat number and EVENT NUMBER

When I create a query of and ask for the EVENT NUMBER as the criteria - I
can update the records.

I'd like to merge the file with another file or query that contains the
EVENT NUMBER.

When I do that - it selects the matching EVENTS but will not let me update
the records.

What am I missing here ?

Thank you

Rick

 

[[MVP] S.Clark]

Describe in more detail the concept of "merge the file with another file or
query"

What's a file?
Can you write the data to a temp table, which in essence Merges the data to
one table, but uses multiple action queries?
What is the unique key for these three fields?

 

[John Spencer (MVP)]

I believe you have to include the Primary Key field or fieldS (multi-field
primary key) if you want to do updates on the query. Access wants to know which
specific row you have.

 

[Rick]

Sorry - old programmer terms.

I have a table that contains:

event number,row,seat,customer

I want to update the customer.

To find the record I can do a query - asking [enter event number] [enter
row] etc...

Since I am usually working with the same event number at one time - I'd like
to have another table contain the "current event number". I would do a
query linking both tables. This part works.

Problem is that I cant update the table containing the customer field.

Hope that explains it better.

Thanks in advance.

Rick

 

[[MVP] S.Clark]

Probably a unique index or primary key on both of the tables.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting