Cannot open detail form of ID because no data present yet.

[jjake]

So i have 3 tables.

tblEquipment
EquipmentID, EquipmentName, EquipmentType

1, Reactor 1, 1
2, Vehicle 1, 2
3, Tower 1, 3


TblEquipmentType
EquipmentTypeID, EquipmentType

1, Reactor
2, Vehicle
3, Tower


TblReactorDetails
ReactorDetailsID, EquipmentID(from tblEquipment), EquipmentDetails1, Equipment Details 2

1,1, Test information 1, Test Information 2


My problem. In my 1st form i add equipmentID's and assign them with an EquipmentType.

I then have a table that stores all the details of that type of equipment per the EquipmentID. My issue is that if i use the table to enter data i can view the 2nd form (FrmEquipmentDetails) to view the data i already entered.

If i open the 2nd form using a filter by ID to show the equipment so i can add the data the Equipment does not show because i haven't assigned a record in that table for it yet. How do i get around that if i enter a new piece of equipment in tblEquipment, it will assign a record for it in the required table tblReactorDetails etc?

 

[Uncle Gizmo]

I don't get why you have a ReactorDetails table?

Sent from my SM-G925F using Tapatalk

 

[jjake]

I did it that way because I have 10 different types of equipment and they all have different fields for details, maybe 30+.