How do i create a macro to display/open the main database window from a switchboard by using a command button?

Hi,
you can select 'Minimize'action for your macro and assign it to the switchboard form button. That will minimise your SW form and by default activate database window.
Not very sophisticated, but i think it should work.
HTH

Chris

Or, if you want a macro to actually do the trick you can select:

In the ACTION: RunCommand
In the COMMAND: WindowUnhide

And then if you want to hide it again, just make sure that the database window is selected and run

ACTION: RunCommand
COMMAND: WindowHide

BL
hth