• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Edit the Results of an Access Join Query

I have two tables that exist in a MySQL Database, that are connected to my
Access Application over an ODBC connection, which is linked.

I want to be able to join together two tables in a query and edit the results.

SELECT 
fr.CIS_ACCOUNT_ID, 
fn.OFFICER_NAME
FROM Fileroom AS fr 

LEFT JOIN fin_prod AS fn 
ON fn.CIS_ACCOUNT_ID=fr.CIS_ACCOUNT_ID;

Open in new window


The CIS Account ID is unique in both cases, however;
1 might have more than the other. Is it possible to edit
the results of this query?
0
JustinW
Asked:
JustinW
1 Solution
 
JustinWAuthor Commented:
Figured it out;
Changed the Joined Fields (cis_account_id) to a primary key in both tables
0
 
Rey Obrero (Capricorn1)Commented:
see this link for possible solution

When can I update data from a query
http://msdn.microsoft.com/en-us/library/aa198446%28office.10%29.aspx
0
 
peter57rCommented:
I don't really understand why you ask the question here rather than just trying it?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now