you know how Incidents Table & Witness table both have INCIDENT ID field. I am trying to create a child form in the witnesses tab, which shows ONLY THE WITNESSES RELATED TO THAT PARTICULAR INCIDENT.
See attached database: (especially WITNESSES TAB)
Now the witnesses tab has datasheet view of all the witnesses RELATED TO THAT INCIDENT. and when you change incident, the witnesses will change as well. (so that datasheet view of the child form is connected to incidents somehow.
But another form tht should pop up when user clicks on the witness datasheet (in witness tab) is not connected to anything - i haven't figure it out yet. So if the user adds witnesses to it, then those witnesses will not be connected to any incidents (redundant witnesses). But there must be some way to connect it to
Man i need to learn VBA.
I am wanting to do the same for all other tabs (actions - Insurence tab will have communications with insurer in datasheet view - Property damage tab will have Property & damage details from tbl_property & injury recovery will have injury recovery process in datasheet view)
View attachment IncidentManagement2007-2.1.zip