I have a problem with one of my forms - I have the following forms
Customer Forms - (it has all my customers information, the projects connected to that customer and the equipment the customer owns)
Project Forms - (it has Information about projects I've done, The hours spent on the project, and the equipment repaired with that project)
Equipment Forms - (the Equipment details and what projects they have been involved with)
The problem is that when I fill out a project form (that in turn updates the Customer and equipment forms). BUT once I have filled these details the Project Tab in my EQUIPMENT FORM doesn't update properly. Instead of each Equipment having a list of Projects involved with that Equipment it list all the Projects involved with ALL THE PROJECTS.
I know this is a complicated question so below is some screen shots of information that maybe helpful
First I fill out my Project Forms
PROJECT FORMS (HOURS) - http://i132.photobucket.com/albums/q23/Dnallov/ProjectFormsProjectHours.jpg
After filling out the Project form I check my Customer form and things have gone well
CUSTOMER FORM - http://i132.photobucket.com/albums/q23/Dnallov/CustomersForms.jpg
But then when I go to my Equipment form (to the Project Tab) it lists all the projects instead of the ones connected to the equipment
EQUIPMENT FORM (WHERE MY PROBLEM IS) - http://i132.photobucket.com/albums/q23/Dnallov/EquipmentForms-1.jpg
I thought that maybe my Complicated relationships was to blame
RELATIONSHIPS - http://i132.photobucket.com/albums/q23/Dnallov/Relationships.jpg
OTHER TABLES - http://i132.photobucket.com/albums/q23/Dnallov/TablesFormsandwhatnot.jpg
Thank you
P.S - If you need any more information, just let me know
Customer Forms - (it has all my customers information, the projects connected to that customer and the equipment the customer owns)
Project Forms - (it has Information about projects I've done, The hours spent on the project, and the equipment repaired with that project)
Equipment Forms - (the Equipment details and what projects they have been involved with)
The problem is that when I fill out a project form (that in turn updates the Customer and equipment forms). BUT once I have filled these details the Project Tab in my EQUIPMENT FORM doesn't update properly. Instead of each Equipment having a list of Projects involved with that Equipment it list all the Projects involved with ALL THE PROJECTS.
I know this is a complicated question so below is some screen shots of information that maybe helpful
First I fill out my Project Forms
PROJECT FORMS (HOURS) - http://i132.photobucket.com/albums/q23/Dnallov/ProjectFormsProjectHours.jpg
After filling out the Project form I check my Customer form and things have gone well
CUSTOMER FORM - http://i132.photobucket.com/albums/q23/Dnallov/CustomersForms.jpg
But then when I go to my Equipment form (to the Project Tab) it lists all the projects instead of the ones connected to the equipment
EQUIPMENT FORM (WHERE MY PROBLEM IS) - http://i132.photobucket.com/albums/q23/Dnallov/EquipmentForms-1.jpg
I thought that maybe my Complicated relationships was to blame
RELATIONSHIPS - http://i132.photobucket.com/albums/q23/Dnallov/Relationships.jpg
OTHER TABLES - http://i132.photobucket.com/albums/q23/Dnallov/TablesFormsandwhatnot.jpg
Thank you
P.S - If you need any more information, just let me know
Last edited:
