Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / August 2005

Tip: Looking for answers? Try searching our database.

Table Design

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bryan Hughes - 08 Aug 2005 17:56 GMT
Hello,

I have a Case File management db.  There can be multiple clients in each
case file.  Each case file has a primary contact.  Each client also can have
separate addresses and address history.  It is possible that the Primary
Contact is not a client.

How should set this up that if the Primary Contact is a client if the
address is changed in the client area the primary contact is updated, or if
the address is changed in the primary contact then the address is changed in
the client area.

-TFTH
Bryan
Sharkbyte - 08 Aug 2005 21:28 GMT
Set up an indicator, from either table, that identifies a client as a Primary
Contact.  Then use an If Statement to update the other address record.

Sharkbyte

> Hello,
>
[quoted text clipped - 10 lines]
> -TFTH
> Bryan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.