Reverse Entry???

  • Thread starter Thread starter Bill
  • Start date Start date
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 selection
from a combo box on
the subform.

What I need 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.

ie ProjectZ goes in Col1 and ProjectA is manually entered in Col2 and then
automatically, somehow, ProjectA is entered in Col1 and ProjectZ into Col2,
obviously in another row.

If possible 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!!

Any help appreciated.

Regards.
Bill.
 
First you need to open the table in design view and click on menu VIEW -
Indexes. Build an index of the two fileds and set as unique.

Then run an append query that appends field1 to field2 and field2 to field1.
 
Thanks Karl, I will give that a try.


KARL DEWEY said:
First you need to open the table in design view and click on menu VIEW -
Indexes. Build an index of the two fileds and set as unique.

Then run an append query that appends field1 to field2 and field2 to
field1.
Click to expand...
 
Back
Top