Linked Custom Properties to Drawing from Assembly and Parts in same drawing

Hello, so i am making a drawing for an assembly on one sheet and the various parts on the proceeding sheets, I am trying to configure the costume properties in a manner that the part number field will automatically populate with the part number of the part on that particular sheet and that sheet only. I have created custom properties for assembly numbers and part numbers and linked them in a text field on the drawing but the field only populates with the part number of the part or assembly on the first sheet and not the part number of the model on that sheet.

I have attached the Sheet format and the costume properties for parts, assemblies, and drawing

Thank you

SolidworksDrawings And Detailing