Do you have a window in the upper portion of your foyer? I have a two storey foyer and we simply centered the chandelier on the window.
As far as height over a dining table, I'd think that regardless of the height of the ceiling, the regular "rules" would apply. I've seen a bunch of different sources for chandelier size and height. I've put a link to one below |
Here is a link that might be useful: Chandelier size, height, etc