I have multiple Mice with individual ID numbers. Some of these mice and the tissue we collect from them have come from previous mice. Right now, on the Specimen layout, I have the Mice ID, a FROM field, and a TO field. Next to the TO and FROM fields, I have a button set up so that it will take me to the Mouse ID record where it came from and where it went to. So, for instance, Mouse 25 came from Mouse 20 and went to Mouse 30. Right now I have to enter both those numbers, and when I hit the GO button next to it, it will take me to record Mouse 20 or Mouse 30.
What I want to be able to do is when I enter that Mouse 25 goes TO Mouse 30, I would like the FROM field on Mouse 30 to automatically fill in as 25. The button GO is single step and it is as follows: Go to Record/Request/Page [With dialogue:Off; Specimen :: TO]. It has worked so far. I just want the FROM field to be automatically filled in from another record's TO field. Any advice?