Results 1 to 13 of 13
  1. #1
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107

    Must be a relationship issue of some kind


    Click image for larger version. 

Name:	Messages.jpg 
Views:	89 
Size:	166.9 KB 
ID:	26175Click image for larger version. 

Name:	Relationships.jpg 
Views:	89 
Size:	100.8 KB 
ID:	26176I have a contact person with many messages. However when I go to the next contact the previous contact messages come with the new record. I think I have my relationships assigned right.

  2. #2
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107
    I'm also having an issue with the phone number. I set the input mask to (999) 999-9999 and when I enter the number in the field that is how it appears but once I exit the field it looks like this. 9999999999. What am I missing?

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    not sure what your question is nor clear on what the db is supposed to do, but looks to me like your concerns and messages tables should have a citizen family key to link to citizenid in your citizen table (you have the key in your concerns table, but not using it)

  4. #4
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107
    The db is for taking calls from citizens. So ONE citizen. When working with a citizen we may call them several times and leave messages. So MANY messages to EACH citizen. If I'm on Citizen "A" and add 4 messages to the message tab and then navigate to the next citizen. Citizen "B". The messages from Citizen "A" are in the message tab when the message tab needs to show the messages for citizen "B". I'm sorry if this is not making since.

  5. #5
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107
    Is this right? Nope... Wait...
    Attached Thumbnails Attached Thumbnails Relationships2.jpg  

  6. #6
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107
    Click image for larger version. 

Name:	Relationships2.jpg 
Views:	86 
Size:	104.8 KB 
ID:	26178Try this...

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    taking calls from citizens
    call/message same thing?

    A Citizen may have 0,1 or Many Concerns
    A Citizen may make 0,1 or Many Calls

    What is a Message? Is it the recording of the "essence" of a Concern?
    Does a Message relate to a Concern?
    Does/Can a Concern get raised/recorded without a Call or Message?

    Get your "business" described, build a model, test your model; then, when it works(supports the business) build the database. Your current relationships appear to be 1:1 which I don't think matches your needs.
    Last edited by orange; 05-24-2018 at 11:28 AM. Reason: spelling

  8. #8
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067
    If it was me I would modify your data structure a bit.

    Citizens table
    citizenID
    citizenname
    citizenNumber

    Messages tbl
    MessageID
    CitizenID
    Messagedate
    messagetype
    message

    Concerns tbl
    ConcernsID
    citizenID
    DateReceived
    AssignedTo
    RoadNumber
    Location

    You do not need a link between Messages and Concerns. You do need a 1 to many link between Citizens and Messages and a 1 to many link between Citizens and contacts
    CitizenID

  9. #9
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107
    Yep that got it guys... Thanks a ton. But nothing took until after I went back into my sub-form and relinked them to the original forms. It was weird. But it's working as designed now. Thanks again...

  10. #10
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107
    The one thing I don't understand well is relationships. I did however over trial and error get the effect I was after. However... I'm not sure how I did it. But it's working so I'm not going to mess with it. I just can't explain how I fixed it.

  11. #11
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You might try watching some free video tutorials by Dr.Daniel Soper that will help you with the concepts.

    Intro to Database
    The Relational Model
    Data Modelling and the ER Model

    Here is a different set of videos by a different presenter to complement those above.
    These are free youtube videos from Mark Serva that deal with entity relationships, modelling, cardinality, ....
    The playlist is listed here.


    Good luck with your project.
    Last edited by orange; 03-08-2017 at 03:08 PM.

  12. #12
    Collins is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2015
    Posts
    107
    Thanks Orange...

  13. #13
    mbarnesca is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    5
    Thank you. I believe my challenge is I can build table. I can create the relationship. I can do a simple query off table or even link it. My challenge is Theory. Am I supposed to make append table...make table?

    I have literally viewed dozens upon dozen of Google searches, YouTube videos. Tried manipulating Northwind or even another sample template but it was tied to several subforms and macros and even more tables than what I am going for.

    Just curious if it is not just an expression I am missing in this pic?Click image for larger version. 

Name:	SumorCount.PNG 
Views:	68 
Size:	23.4 KB 
ID:	26259

Please reply to this thread with any new information or opinions.

Similar Threads

  1. What kind of relationship should I use for a two table database?
    By receptionist_dude in forum Database Design
    Replies: 5
    Last Post: 06-20-2016, 05:11 PM
  2. Replies: 5
    Last Post: 01-08-2015, 02:08 PM
  3. Replies: 4
    Last Post: 04-01-2014, 02:11 PM
  4. Issue with one to many relationship
    By ryancgarrett in forum Access
    Replies: 2
    Last Post: 08-06-2013, 06:15 AM
  5. Possible Relationship Issue?
    By Bill Sperry in forum Forms
    Replies: 7
    Last Post: 03-20-2012, 11:29 AM

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