Relationships

R

ryanb

Hi all,

I'm trying to setup a type of relationship, but am having no luck.

What i want to do in this relationship is have a tickbox update i
another table when it is ticked on one table.

how it works is we have users request something and in turn we fill ou
the form, in the table where we store our information on forms done
want the tick box in that table to update the one in the other tabl
when clicked.

there is allready a relationship between the 2 tables for a fiel
called 'request number' which links the users request to our table o
forms we have filled out.

the purpose of this is that so when we fill in a form and send it, i
in turn marks a box in the request table which we will use as the ke
when checking if the request has been completed or not.

hope this makes sense

Ryan
 
Top