Problem with Layer created from Selected Features

[AlexSadurski]

Hello,

I have a map where I've loaded the bulk data from the company database. I have data in an excel spreadsheet that I have imported and joined to one of the data sets in the corporate data. From this joined table I have created a bunch of layers using the "Create Layer from selected features" function. All was working OK (points were plotting, all layers were working fine) until one day last week the attribute tables of the layers I had created were blank and the points were no longer plotting on the map. Both the corporate database attribute table and the imported table are full of data and not blank, also the corporate data plots on the map no problem. However my created layers no longer plot on the map.

Does anyone have any solution or advice on this matter?

Alex

[AlexSadurski]

Thank you Dan.

Our current databases don't contain the information I need but the idea is to eventually move to an access database, but that is still some time away. This is a temporary situation to present to upper management until our databases are updated in the future

[MichaelVolz]

If both the corporate data and the spreadsheet are being updated on a continual basis (daily, weekly, etc.) you probably would want to consider using ModelBuilder or python to script out the copy process and subsequent join so it is automated and always up-to-date and does not get corrupted like your current selection set did.

[AlexSadurski]

This seems to be a difficult task that I was not prepared for haha.