Jan,
Please provide the table relationships and SQL view. Are the tables joined on primary and foreign keys?
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 30 Mar 2015 17:19:10 -0700
Subject: [MS_AccessPros] Can't update in a Query
I have a Query with 3 tables. Patrons (my contact list) Emails (multiple email accounts per patron) and Status (Deceased, attended Fund Raising dinner, Donor, Board Member)
My links look ok and I am getting the correct data in the query but I cant update the records in the query. None of the fields seem to allow update.
I am certain this is something simple but.....
Any thoughts?
Thanks
Please provide the table relationships and SQL view. Are the tables joined on primary and foreign keys?
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 30 Mar 2015 17:19:10 -0700
Subject: [MS_AccessPros] Can't update in a Query
I have a Query with 3 tables. Patrons (my contact list) Emails (multiple email accounts per patron) and Status (Deceased, attended Fund Raising dinner, Donor, Board Member)
My links look ok and I am getting the correct data in the query but I cant update the records in the query. None of the fields seem to allow update.
I am certain this is something simple but.....
Any thoughts?
Thanks
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar