auto complete checklist

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
 

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