We have a table with part numbers which can be superceeded with new parts.
We need to keep the link to the old part with a link to the new part.
So in the table we have Part Number (original) and NewPartNumber which will link to the new Part Number.
Part number 1234
NewPartNumber 4567 (which is also a Part Number 4567)
Any ideas thanks?
To make this work automatically, the Key field of your table will first need to be changed to the Part # field. Obviously with that much existing data, this app is seriously "In production". So, you need to Copy your app and do these changes as a test first in the Copy Of app.
To make the Part number field be the Key field it will need to be Unique and non blank. I suggest that a first step is to scrub your data by making a summary report on Part number ands then click the count column twice and save to save the report sorted by duplicate part numbers at the tip. Then they all need to be cleaned up.
Contact me me off line via the information in my Profile if you would like some consulting assistance with this change.
If the old part and new part are in the same record then there must be an easier way of making a link to the new part?
I already have the parts linked by relationships to drawings which have multiple parts so breaking that relationship is something i just don't want to do. Is there another approach?
However, if you do not want to just want to make any new relationships, you can just create a new field of type Report Link. On the left side select the Part # (Original) on the right side navigate to the same app and table and select NewPartNumber#.
Then put that field on the form and have the records for the Original Parts appear directly on the report. That last part is set in Form properties.