Incident Tracker - Cannot add record: join key of table "tblIncident Info" not in rec
Hi guys,
I've managed to start a few tables, a log in form and a little flash screen. I then created a form that will serve us a fill-up form.
But when I tried to input data to my "Location of Incident, Time, Date , Narrative and Resolution fields it doesn't allow me to and displays an Error message saying Cannot add record; join key of table "tblIncident Info" not in recordset.
To what I see, I think I mess up with my relationships. Or I don't know.
I would be willing to provide a link to my relationships field but i'm still not allowed to do so. I've already check the post by Nano but to no avail I can't find the solution to my problem there.
Hope someone can help me with this.
EDIT:
What i want to do is that there would only be ONLY one Form with tabs and that a user will just input the data on the fields provided. Is that advisable? Or would it be better if there are multiple forms?
I also already did several revisions and now on this current one I've decided to use a design concept from databaseanswers since it's closely the same design to what i have in mind.
I will post a zip file of my db later.
Hi guys,
I've managed to start a few tables, a log in form and a little flash screen. I then created a form that will serve us a fill-up form.
But when I tried to input data to my "Location of Incident, Time, Date , Narrative and Resolution fields it doesn't allow me to and displays an Error message saying Cannot add record; join key of table "tblIncident Info" not in recordset.
To what I see, I think I mess up with my relationships. Or I don't know.
I would be willing to provide a link to my relationships field but i'm still not allowed to do so. I've already check the post by Nano but to no avail I can't find the solution to my problem there.
Hope someone can help me with this.
EDIT:
What i want to do is that there would only be ONLY one Form with tabs and that a user will just input the data on the fields provided. Is that advisable? Or would it be better if there are multiple forms?
I also already did several revisions and now on this current one I've decided to use a design concept from databaseanswers since it's closely the same design to what i have in mind.
I will post a zip file of my db later.
Last edited: