CJBIRKIN
Drink!
- Local time
- Today, 23:32
- Joined
- May 10, 2002
- Messages
- 255
Hi,
For my latest DB i am developing an easy to use synchronisation routine.
Part of the system updates FK fields.
Currently i'm using a SQL Update query. Ideally i would like to simplfy this in the following way.
1. Pass Table name and Primary key field name to function.
(Can do that.)
2. Select table in some way. table def?
3. Find all tables and the fields that are linked to the field that i passed into the function.
4. Update the related field.
(Can do that.)
I've had a look at the relations object but i am still not sure if this is possible.
Can any one help?
Cheers
Chris
For my latest DB i am developing an easy to use synchronisation routine.
Part of the system updates FK fields.
Currently i'm using a SQL Update query. Ideally i would like to simplfy this in the following way.
1. Pass Table name and Primary key field name to function.
(Can do that.)
2. Select table in some way. table def?
3. Find all tables and the fields that are linked to the field that i passed into the function.
4. Update the related field.
(Can do that.)
I've had a look at the relations object but i am still not sure if this is possible.
Can any one help?
Cheers
Chris
