ACCESS 07 doubt

Message Topic Search Topic Options Post Reply Create New Topic Printable Version

   haii frnds..

 i have 2 table emp1 and emp2 both have ref_ID and Cust Colum. now i want if the emp2.cust is equal to NULL automatically inserting from emp1 to emp2.
any triggers like apply here..?
kindly reply mee...
URGENT

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version
shamsu Members Profile Send Private Message Find Members Posts Add to Buddy List Bronze Member Joined: 27 Feb 07 Location: United Kingdom Posts: 67	Quote Reply Topic: ACCESS 07 doubt Posted: 02 Mar 09 at 11:27am
	haii frnds.. i have 2 table emp1 and emp2 both have ref_ID and Cust Colum. now i want if the emp2.cust is equal to NULL automatically inserting from emp1 to emp2. any triggers like apply here..? kindly reply mee... URGENT


Jijo Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Admin Group Joined: 31 Dec 05 Location: United Kingdom Posts: 495	Quote Reply Posted: 04 Mar 09 at 12:46pm
	I think access 97 doesn't support triggers. But i have seen an interesting article on using triggers in access. May be new versions are supporting it. Just have a look.. http://office.microsoft.com/en-us/access/HP030854151033.aspx
	Online Tourism