John,
From your suggestion & instruction what i got is that table CST Transaction should not have in its design and structure fields SurName GivenName and some other fields if i have included in table CST Transaction of table Members except the linked field MemberID, and same rule should be applied in other tables.
I think i am making this basic mistake through out my all databases.
I hope removing fields SurName, GivenName etc from table CST Transaction would not effect its other data, and then perhaps i have to modify the Record Source/Sql of some reports pertaining to data entry of CST Transaction (which is actually data of CST Participants).
Before taking these steps how would you suggest to take backup of my data, should i simply copy paste data file to another folder or there is some other recommended method?
Regards,
Khalid
On Saturday, August 23, 2014 11:51 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Khalid-
The fields SurName and GivenName should appear in the Members table and ONLY the Members table. Those fields should not be duplicated in other related tables. If you need these values when looking at a related table such as CST Transaction, you should include the Members table in the query linked by MemberID and display the values from the related row in Members.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 23, 2014, at 7:16 AM, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi all,
I have some forms for Search & Edit. Let me take an example of Form "Search Edit Members" its Record Source is query "Search Edit Members Query" with Sql:
SELECT Members.MembershipTitle, Members.MembershipType, Members.MemberID, Members.GenderStatus, Members.SurName, Members.GivenName, Members.MembershipStartDate, Members.MembershipExpireDate, Members.DesignationSOC, Members.Dob, Members.MemberEC, Members.Nationality, Members.Organization, Members.OrganizationDesignation, Members.EduQualification, Members.EducationStatus, Members.[Postal Address], Members.MainCityName, Members.TelephoneOffice, Members.TelephoneResidence, Members.FaxNo, Members.MobileNo1, Members.MobileNo2, Members.MemberEmail, Members.SkypeID, Members.ViberID, Members.FacebookID, Members.[CNIC Number], Members.[CNIC IssueDate], Members.[CNIC ExpiryDate], Members.PassportNo, Members.[Passport IssueDate], Members.[Passport ExpiryDate], Members.ProposedBy, Members.RecommendedBy, Members.Working, Members.Photo, Members.Country
FROM Members
WHERE (((Members.Working)=True))
ORDER BY Members.MemberID;
Table Members has Primary Key MemberID and it has one-to-many relationship with table "CST Transaction" when i do edit MemberID on this form, MemberID is updated in table "CST Transaction".
My issue is that if i edit "SurName" and "GivenName" they do not update in table "CST Transaction" and some other tables, in the same manner there may be chance of editing other fields.
I did tried with the After Update event on "SurName" field, but nothing happened may be this is wrong way i am trying.
Private Sub SurName_AfterUpdate()
Dim varV As Variant
varV = DLookup("[SurName]", "CST Transaction")
varV = Me.SurName.Value
End Sub
Need help please.
Khalid
__._,_.___
Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar