Error on form

[Guest]

I have a database that is used to store Contractor, Contracts and also the
contracts that have been applied for by the contractors.

i have them all linked together so that when details are put in about
contracts then this information appears on the contractor details also.

what im having problems with is when im trying to type some details in on a
form it says "cannot add record(s); join key of table 'TContractsAppliedFor'
not in recordset." but if i type the same information in the table then it
works fine.

can anyone help with this please?

 

[Guest]

hi,

you need to consider the table relationships and the foreign key links.

You can also consider the application CONAPP at
http://www.designing-systems.com/products/conapp/
this will help you in visualizing the links between contracts, contractors
and other dimensions.

Regards,

 

[Guest]

hi the relationships between all my tables work fine cause if i type
information into the tables then it links with all the other ones and also
appears correctly on the forms.

its just this one section on the form that i get the error appearing, but if
i go to the same fields on the table i can type them in fine there.