The user has full control on which table's record to be shown on the map by selecting the table, and setting filters for it.
If a marker on the map is clicked, a popup window will open. The content of the popup window is fully customized by the user and has full capacity of server side scripting.
A user can use the default map or incorporate a pre-made ArcGIS map.