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?
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)
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.
Is this right? Nope... Wait...
call/message same thing?taking calls from citizens
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
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
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...
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.
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.
Thanks Orange...
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?