Sub Page_Ready()
Log("ready!")
page.RestoreNavigationBarPosition
' Update the table with any new or changed data
RefeshTable ' (notice a short delay while results are being retrieved)
End Sub
' show data only WHERE Main.comp_id = logged in users selection (privilege).
Sub RefeshTable
Dim sq As SQL
sq = DB.pool.GetConnection
tblContacts.Clear ' drop old list or it shall duplicate
FillcontactosTable(tblContacts , sq.ExecQuery("SELECT PK, Employee_no, First_name, Last_Name, Pin FROM emp WHERE comp_id = "&Main.comp_id&" ORDER BY Last_name "))
tblContacts.Refresh ' show new additions, edits or deletes.
sq.Close
End Sub