Field to subField

[Guest]

I have a database that I am trying to build that needs to use subfields, like
submenus.
Example:
tblProblems
-Prob_Id=(autonumber)
-DoO=Date (Date of Occurance)
-Type=number (Look-up to type of problem: Mechanical,Electrical, etc)
-Sect=number (look-up to table:Section of Building:Admin,Outside,etc)
-subSect=number (look-up to table: subSection of Building:Offices,
RR,classroom,etc)
-Descript=Memo (Description of Problem)
-Repaired=Yes/No
-FrmlRpt=Yes/No (Formal Report describing events leading to problem)

Sect and subSect are linked together in the table for subSect. I want to
restrict field subSect by what is in field Sect. Is this possible and if so
how. With forms, I can restrict using subforms(linking child fields), but I
can not make it save into the tblProblems.

 

[Guest]

Never mind. I had a keyboard-to-chair error. I just updated the field in a
form to restrict the subsections.

Thanks

 

[Guest]

You might consider using a RepairDate instead of Repaired=Yes/No.