M
Murray
Hi All
I have 3 tables. The First is called Contract and has a field called
ContractID. The second Table is called Job and is linked to the first via the
ContractID. The third table is called Child and is also linked to Contract
via ContractID. This has been working fine because till now we have had one
contract that creates one job and the child was linked to the ContractID and
childs could have been multiples.
We have now changed to now have multiple jobs linked to a single Contract
and the jobs will have multiple childs.
I have been able to get the multiple jobs works but I now need to change the
relationship of the child so that it is linked to the jobID and not the
contractID. I created a copy of the child table and removed the field for
ContactID and linked the child to JobID.
When I run a query I get a error unless I re establish the link to ContractID.
Any ideas were I have gone wrong?
Thanks
I have 3 tables. The First is called Contract and has a field called
ContractID. The second Table is called Job and is linked to the first via the
ContractID. The third table is called Child and is also linked to Contract
via ContractID. This has been working fine because till now we have had one
contract that creates one job and the child was linked to the ContractID and
childs could have been multiples.
We have now changed to now have multiple jobs linked to a single Contract
and the jobs will have multiple childs.
I have been able to get the multiple jobs works but I now need to change the
relationship of the child so that it is linked to the jobID and not the
contractID. I created a copy of the child table and removed the field for
ContactID and linked the child to JobID.
When I run a query I get a error unless I re establish the link to ContractID.
Any ideas were I have gone wrong?
Thanks