I am trying to create a form that I can use to create new categories and sub-categories of equipment. I have been struggling with this form for about 2 days now, could I get some assistance? Not asking for someone to do it for me, just point me in the right direction or let me know what is the correct way to do this.
I the following tables with the following categories
tblEquipmentType_Main
- EquipmentTypeID
- EquipmentTypeName
tblEquipmentType_Sub
- EquipmentSubTypeID
- EquipmentTypeID
- EquipmentSubTypeName
tblEquipmentType_Join
- JoinID
- EquipmentTypeID
- EquipmentDescription
I am trying to have a single form to create equipment types and sub-types but can't seem to fit all the pieces together properly to get it working.