B
Bill
I have a dependencies table that identifies projects that are dependent on
each other. It only has two columns. The first column is updated
automatically via a subform, the second column is populated via a combo on
the subform.
What I would like is that if I identify that ProjectZ is dependent on
ProjectA, I would like the reverse to be automatically added to the
dependencies table. ie that ProjectA is dependent on ProjectZ.
Obviously I would also like deletions to be handled automatically too.
Can this be achieved via a query or relationship of some sort, or even a
macro, as I don't have time to resort to the VB learning curve!!
I appreciate this may not be a 'forms' question but I'm not sure where else
to go given that I don't want to get into VB.
Any help appreciated.
Regards.
Bill.
each other. It only has two columns. The first column is updated
automatically via a subform, the second column is populated via a combo on
the subform.
What I would like is that if I identify that ProjectZ is dependent on
ProjectA, I would like the reverse to be automatically added to the
dependencies table. ie that ProjectA is dependent on ProjectZ.
Obviously I would also like deletions to be handled automatically too.
Can this be achieved via a query or relationship of some sort, or even a
macro, as I don't have time to resort to the VB learning curve!!
I appreciate this may not be a 'forms' question but I'm not sure where else
to go given that I don't want to get into VB.
Any help appreciated.
Regards.
Bill.