Convert yes/no's to text records

  • Thread starter Thread starter Nick Mirro
  • Start date Start date
N

Nick Mirro

I use a popup form with checkboxes as a patient treatment 'script. I would
like checks to cause fields in another table (in addition to record source
table with yes/no's) to be filled in. The reason for the checks is
generation of script (report), which looks best with checks.


tblItems tblProcedureCodes

Check Causes this field in separate table to be completed using
lookup table

Item 1 Procedure code A
Item 2 Procedure code B


(How can I code 'script popup to complete procedure code records in another
related table?)


tblVisits tblItems* tblProcedCodesUsed tblProcedCodes

Parent Child Child Lookup

VisitID visitID visitID ProcedCodes
Item1 Code1
Item2... Code2


*checks
 
Nick Mirro said:
I use a popup form with checkboxes as a patient treatment 'script. I would
like checks to cause fields in another table (in addition to record source
table with yes/no's) to be filled in. The reason for the checks is
generation of script (report), which looks best with checks.


tblItems tblProcedureCodes

Check Causes this field in separate table to be completed using
lookup table

Item 1 Procedure code A
Item 2 Procedure code B


(How can I code 'script popup to complete procedure code records in another
related table?)


tblVisits tblItems* tblProcedCodesUsed tblProcedCodes

Parent Child Child Lookup

VisitID visitID visitID ProcedCodes
Item1 Code1
Item2... Code2


*checks
Click to expand...

It's not at all clear to me what you are trying to do.
However how a "yes/no" field appears in a form or report is a formatting
issue and requires no code.
As for using a "script:
Access has both macros which should be rarely used and a full language which
is *not* a scripting language.
From the little I do understand it would appear that proper table and form
design should do all that you require.
 
Then you need to buy some books and read help files.
If you are doing a medical app without knowing what SOAP notes are you
should ask.
 
Back
Top