I am hoping that there are techniques available in PS or LR to merge the focus from two objects into one. I know this sounds confusing so I'll demonstrate with the following photos. The shots were taken with the normal lens wide open to minimize the DoF for this experiment.
The area of interest in these photos is the surface of the granite shelf in the foreground. In the first shot, the focus is on the surface and the dust on the shelf can be clearly seen. Please don't tell the wife I shot this before she had a chance to dust!
In the second photo, the focus is on the back wall of the room. Although the dust is no longer in focus, there is now a reflection of the back wall on the surface of the granite shelf.
My goal is to combine the images to get the entire photograph in focus. The trick is in getting BOTH the dust and the reflection in focus on the shelf. So far, the best I've been able to do is this. This is actually the merging of four images to try to get sharp focus from front to back, but the shelf focus experiment only needs two images to demonstrate the principle.
Thank your viewing and whatever suggestions you may have.