Hi there,
I have three tables:
Students
Parents
ClassSplits
In my Students table i am making a field called SDD, with which i want an update query to place in there form that table 2 field and 2 field from Parents table and 1 from ClassSplits.
My update looks like this: UPDATE TO:
[students].[SName] & ", " & [ClassSplits].[CClass] & ", " & [Parents].[Paddress2] & ", " & [Parents].[PAddress1]
All the relationships are set up and working, prob being when i run it, the db looks at [students].[SName] (the field from that table to which the update is happening) looks at it as if it is a question query, so when i run it it comes up with a pop up box saying SName with a text box under it, but all the other fields update!
Please help ASAP.
Ta
I have three tables:
Students
Parents
ClassSplits
In my Students table i am making a field called SDD, with which i want an update query to place in there form that table 2 field and 2 field from Parents table and 1 from ClassSplits.
My update looks like this: UPDATE TO:
[students].[SName] & ", " & [ClassSplits].[CClass] & ", " & [Parents].[Paddress2] & ", " & [Parents].[PAddress1]
All the relationships are set up and working, prob being when i run it, the db looks at [students].[SName] (the field from that table to which the update is happening) looks at it as if it is a question query, so when i run it it comes up with a pop up box saying SName with a text box under it, but all the other fields update!
Please help ASAP.
Ta