i have a table for logins,and i want to be prompted immediately there is an entry into the table, that is when someone logs in.

i guess that has to do with triggers,please help me with information on how to do this and what triggers are all about.

I, personally, don't like the idea of triggers, largely because they become undocumented, difficult to find and debug, and can cause large problems!!

However, if you have to use them, look for stored procedure language (eg Informix Guide to SQL: Tutorial ). Triggers are basically stored procedures that are then tied to updating tables or columns in tables.