J
jp
I'm teaching myself Access(2K) as I try to set up an
Equipment Maintenance History database and I think I need
three primary tables with the following relationships.
tblEquipment--EquipID(PK),Description,Vendor, etc
tblMaintHist--MaintID(PK),EquipID(FK),MaintType,MaintDate
tblMaintDetails-DetailID,MaintID(FK),TechID,Comments
The Northwind database has a form called Customer Orders
with 2 embedded subforms. Is there some reason it's a read
only form? I need to set up a form very similar to that
sample so that a technician can see a snapshot
(MaintType,MaintDate) in the first subform with details
available in the second subform but with the ability to
add new maintenance history records(do I need a different
form). Will my table design support this? Thanks for the
assistance
Equipment Maintenance History database and I think I need
three primary tables with the following relationships.
tblEquipment--EquipID(PK),Description,Vendor, etc
tblMaintHist--MaintID(PK),EquipID(FK),MaintType,MaintDate
tblMaintDetails-DetailID,MaintID(FK),TechID,Comments
The Northwind database has a form called Customer Orders
with 2 embedded subforms. Is there some reason it's a read
only form? I need to set up a form very similar to that
sample so that a technician can see a snapshot
(MaintType,MaintDate) in the first subform with details
available in the second subform but with the ability to
add new maintenance history records(do I need a different
form). Will my table design support this? Thanks for the
assistance