Want to be able to edit results in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)


Teri said:
I have a simple query between two tables (with a one to many
Click to expand...
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
Click to expand...
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.
 
Back
Top