Unanswered: updating same record in 2 tables at the same time
ok, next daft question(thanks for answering previous ones!)
I have a main table (mobiles) that has a dlookup to a second table (SLOC) using a field courier address.
using a query (believe it or not i dont have primary key fields) how can i set up an uipdate so that if i need to change a name in the sloc table (cos someone moves) it will also update the mobiles table?
I thoughti new how to do it, but set up a test record and it didnt work.
Would i need to create the record in SLOC as a primary and in relationships select it as a cascade update? is this the easiest way, or can you helpful peeps give me a nice easy solution?
How are you doing to try to do the "referential bit"?
Are you given an error message? How do you know it won't do the referential bit?
If I was forced to guess, I'd say that your data is not referentially clean so when you are trying to apply the enforced integrity, the data is causing it to fail. There's only one solution to that; clean up the data first.