S
Sheila D
Hi
I am working on an Access 97 database which currently has a Form which
utilises fields from 2 tables, Quotations (One) and Orders (Many) The Record
Source is a query pulling required fields from both tables. Each table has a
field JobNo which is an Autonumber in Quotations and automatically updates
JobNo field (Number) in Orders with same no (I think because of relationship
as I can find nothing else)
I now need to add a section for Materials and have created a new table
called Materials and designed a Form which will go in the existing form as a
subform. My problem is the Master side of relationship - when I set to
Quotations.Jobno (which Access suggests to me and is what I want) I get the
error 'The object doesn't contain the automation object quotations'
Any help would be much appreciated
Sheila
I am working on an Access 97 database which currently has a Form which
utilises fields from 2 tables, Quotations (One) and Orders (Many) The Record
Source is a query pulling required fields from both tables. Each table has a
field JobNo which is an Autonumber in Quotations and automatically updates
JobNo field (Number) in Orders with same no (I think because of relationship
as I can find nothing else)
I now need to add a section for Materials and have created a new table
called Materials and designed a Form which will go in the existing form as a
subform. My problem is the Master side of relationship - when I set to
Quotations.Jobno (which Access suggests to me and is what I want) I get the
error 'The object doesn't contain the automation object quotations'
Any help would be much appreciated
Sheila