Tables need to be linked but only sometimes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a quality assurance system. It handles audits. Basically there is a
compliance question which can be answered 'compliant' or 'non-compliant'. If
'non-compliant' a defect must be selected (from a drop-down) and a corrective
action (from a drop-down). In my compliance table, I want to store only the
ID of the defect and corrective action since the text can be quite long.
However, now the user wants to be able to enter their own defect text and
corrective action text. This will be uncommon but I must cater for it. How do
I handle this since I am just storing the ID of the defect and corrective
action and now the text wont be in the table so there will be no ID.
 
This is what I call the "Other Problem", that is, the user wants to have
predefined values but still have the ability to add an Other with matching
text. You can find one solution to this problem on my website
(www.rogersaccesslibrary.com), in a small Access database sample called
"OtherProblem.mdb".

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top