Tables need to be linked but only sometimes

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.
 
R

Roger Carlson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top