I have two tables, simplified here:
1) tblVessels
1000+ records
fields: Vessel_Name, Incident_Date
2) tblProblems
2000+ records
fields: Vessel_Name, Incident_Type, Incident_Severity, Incident_Cause
*There's a one-many relationship from tblVessels to tblProblems. Ex:
tblVessels: Titanic, 9/18/2001
tblProblems: Titanic, Sinking, Total Loss, Iceberg
Titanic, Gear Loss, Severe, Vessel Sway
Titanic, Loss of Life, Severe, Drowning
*I'd like to work instead with only one table; adding a third field to tblVessels like this: Vessel_Name, Incident_Date, Notes. And then combine the 'many' side of the relationship into that new field so my new record is:
tblVessels: "Titanic", 9/18/2001, "Sinking-TotalLoss-Iceberg/GearLoss-Seve-VesselSway/LossLife,Sev,Drown"
You see? The separators in the new notes field dont matter, just as long as I can look at the 'many' related records in one field (prob. type memo)
I realize that I am taking someone else's very well designed database and totally breaking DB rules by wanting to do this-- but its for the sake of simplicity! Thanks in advance for any help---
Andy
1) tblVessels
1000+ records
fields: Vessel_Name, Incident_Date
2) tblProblems
2000+ records
fields: Vessel_Name, Incident_Type, Incident_Severity, Incident_Cause
*There's a one-many relationship from tblVessels to tblProblems. Ex:
tblVessels: Titanic, 9/18/2001
tblProblems: Titanic, Sinking, Total Loss, Iceberg
Titanic, Gear Loss, Severe, Vessel Sway
Titanic, Loss of Life, Severe, Drowning
*I'd like to work instead with only one table; adding a third field to tblVessels like this: Vessel_Name, Incident_Date, Notes. And then combine the 'many' side of the relationship into that new field so my new record is:
tblVessels: "Titanic", 9/18/2001, "Sinking-TotalLoss-Iceberg/GearLoss-Seve-VesselSway/LossLife,Sev,Drown"
You see? The separators in the new notes field dont matter, just as long as I can look at the 'many' related records in one field (prob. type memo)
I realize that I am taking someone else's very well designed database and totally breaking DB rules by wanting to do this-- but its for the sake of simplicity! Thanks in advance for any help---
Andy