Want to be able to edit results in a query

[Guest]

I have a simple query between two tables (with a one to many relationship). The "one" table is called Master, the "many" table is called Ad Sales. They are linked by the ID #. I have a query pulling particular info. I need the Company name from the "master" table so I know who the ad sales belong to

The problem? I want to be able to edit the results of that query, but it doesn't allow me to do so. Is there any way I can re-write the query in order to achieve this? I know if I don't link the two tables in the query, I can pull up all the ad sales records I need, but w/o the company name to match it up - I wouldn't know which records belonged to who

Any suggestions would be greatly appreciated!!

Ter

 

[Van T. Dinh]

Is the Field [ID #] is the PrimaryKey in the Master Table?

I am fairly sure that you need it to be PK.

--
HTH
Van T. Dinh
MVP (Access)

I have a simple query between two tables (with a one to many

relationship). The "one" table is called Master, the "many" table is called
Ad Sales. They are linked by the ID #. I have a query pulling particular
info. I need the Company name from the "master" table so I know who the ad
sales belong to.

The problem? I want to be able to edit the results of that query, but it

doesn't allow me to do so. Is there any way I can re-write the query in
order to achieve this? I know if I don't link the two tables in the query,
I can pull up all the ad sales records I need, but w/o the company name to
match it up - I wouldn't know which records belonged to who.