Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Agreed. Also, there's a current scenario where the actual supplier has offloaded all their support responsibilities to a third party, and it would probably be a good idea to record the details for both of them.

  2. #17
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Quote Originally Posted by Remster View Post
    Doesn't that allow for only one contact per system? We don't need to know who sweeps the floor or who updates security passes, but we do need to know who handles the contract, who manages the helpdesk, who's an expert in such-and-such aspect of the system, and so on.
    Yes that is true. In table SystemQ you could have compound PK of (SystemId,SupplerId and ContactID) to allow multi suppliercontacts per system.

    Just as there could be a change in Supplier, so to could there be changes in SupplierContact, or even supplierContact expertise. Although your primary concern is the current contact, current supplier etc, it seems you have need for some history also. This will impact your design.
    But helpdesk, contract manager, contacts with various expertise are new requirements. Suggest you get the requirements under control and model and test/vet your evolving model.
    Last edited by orange; 06-06-2023 at 06:07 AM. Reason: clarification

  3. #18
    Remster is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Sep 2010
    Posts
    317
    Quote Originally Posted by orange View Post
    But helpdesk, contract manager, contacts with various expertise are new requirements.
    Hmm, not really. In my clarificatory post, I wrote "each system can have multiple contacts". This was precisely to cover contacts with different responsibilities and expertise (although it could also be used for retaining contact history).

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 05-10-2017, 12:43 AM
  2. Permitted users only, restrict database
    By Heathey94 in forum Security
    Replies: 21
    Last Post: 12-08-2016, 01:01 PM
  3. 'Mapping Table' query including all combinations
    By rewritable in forum Queries
    Replies: 2
    Last Post: 06-09-2012, 04:34 PM
  4. Replies: 5
    Last Post: 05-26-2010, 07:13 AM
  5. Replies: 3
    Last Post: 12-15-2009, 01:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums