Im going to try to explain something and I hope it fits.
It looks like your items table needs some new fields : disposition disposition date, replacementitemID, and replacingItemID
It also looks like you could benefit from a self relationship. Create a table occurance of your items table and name it replacement items, (this is simply another view of the same items table so that we can build different relationships to the table.it is NOT a new table)
Create a relationship between the two based on information that will remain the same (PO tag location etc and replacingItem = item:itemid)
In the relationship dialog check the box "Allow creation of records via this relationship" on the relpacement items side
Now you can add a portal to your layout based on the replacement items table occurance.
When you wish to replace the item you can add a row of data in the portal (it will auto populate the fields that the relationship is based on)
You will also need to populate the replacementitemID of the original item record once a new serial id number is created. (these should be an autoenter serial number)
Im sure thats clear as mud :)
Ya... Where is the bottom of this muddy hole? I think I am understand what you are saying but, the self relationship is throwing me through the hoops. Actually I think knowing what to relate and how is giving me a problem. I created a quick visio of what I currently have. I didnt know if you could give a visual to help me understand more.
So what this will do in layout mode after the portal is when someone enters a new serial number in the replacementItemId it will create another record but not, right? Or the portal is going to take them to another screen to enter the data but it is in other self join table.
Then I can set up a search for say serial number in tblItems serialNumber and it will look for that serial number in both self join (replacementItems) and tblItems tables.
Will it also do the samething when I were to search for Tag and it would give me the orginal and warranty replaced serial?