A
Access Africa
I need to make a form with a checklist that will auotmatically be completed
What I need to do is:
I have a table for clients (PK ClientID)
and a table for Responses
I want to be able to have design the checklist to look-up if the clientID is
in the Response Table if it is it needs to cross reference the QuestionID
which is in the Response Table and on the Checklist form and then tick the
question as done in the check box.
(IF [clientID=clientID.tblResponse THEN find QuestionID in tblResponse IF
both true then mark YES])
Any ideas on how to do this?
Natasja
What I need to do is:
I have a table for clients (PK ClientID)
and a table for Responses
I want to be able to have design the checklist to look-up if the clientID is
in the Response Table if it is it needs to cross reference the QuestionID
which is in the Response Table and on the Checklist form and then tick the
question as done in the check box.
(IF [clientID=clientID.tblResponse THEN find QuestionID in tblResponse IF
both true then mark YES])
Any ideas on how to do this?
Natasja