Hello. I'm really struggling with this one. I've got two tables - one with the organization information and another one with information on the different activities it hosts. Sometimes the address of the activity is different than the organization but sometimes they are the same. I am trying to avoid having to type in the information twice if the addresses are the same. Here's what I have set up so far.
I have two separate forms for the organization and activity tables. The organization ID joins the two tables together. First the organization form is filled in. If it is hosting an activity, the activity form opens up with the organization field populated. Here are the some of the fields in the tables. I won't list them all because there are too many and probably aren't relative to this issue.
Table name: tblOrganization
Field names: OrgID_PK, OrgName, Address, City, Zip, County
Table name: tblActivities
Field names: ActivityID_PK, OrgID_FK, AddSame, ActAddress, ActCity, ActZip, ActCounty
Tables are joined by the OrgID fields. The AddSame field is a checkbox that the user will check if the addresses are supposed to be the same.
What do I need to do to copy the organization address fields to the activity address fields? Do I need to run an update query? Do I write something for the OnClick or AfterUpdate property?
Thanks for your help.
Karen
Posted by: k2j1203@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar