in reply to Which way to go?
Another method: create different views. If authority such, use that view, otherwise that view. No need for separate tables either way.
Hope this helps.
Jeroen "We are not alone"(FZ)