Hi
I'm a newbie so please bear with me.
I have a table which contains two relevant record fields,(among others)
1. PersonID (autonumber & key field)
2. OtherID. (number type field)
So say record one has PersonID of 1 and no entry in OtherID.
when another record is created say Record 5 PersonID is 5 and OtherID then has 1 entered into it.
what I want is for record1 (personID1) to have the value of 5 entered into OtherID
this would happen because PersonID 5's OtherID equals the Person1's PersonID of 1
I am trying to match Partners in a database of people if that helps and want the older entry updating when a new entry is made.
Sorry if its long winded but don't know how else to explain my problem. - I as yet don't do much coding just simple VB from the "properties" tab.
Thanks in advance.