Oracle 7, Forms 4 trigger question

I'm working with Oracle 7.0.16, and Forms 4.0.12. I would like to force a user to enter a record if a FK in 2nd table can not be found via a LOV lookup. I don't want to lock it down to the LOV from the 2nd table, but if a new value is being entered, I would like to create a record in that table.

	Table AA			Table BB
	--------			--------
	.				User_id		char(20)
	.				Name
	User_id		char(10)	Address
	Amount of Sale	char(20)	.
	.				.
	.				.
	.

User_id field has a LOV which lists the User_id, and Name from Table BB. If a new entry is being put in Table AA, I would like to force the user to enter the corresponding fields in table BB. I have tried to look for a built-in trigger that would check the result of a select statement at the time of commit on Table AA with no luck. I was very suprised not to find any check_return_of_function trigger.... or such.

<Aram>

--


/  Aram Mirzadeh - BNL - (516)282-5767      |  				/

/  email:   mirzadeh_at_pmdb.sep.bnl.gov       |	     NOTE:		/

/  IRCNick: Wolfman / DND: GOD!             |   (this space left 	/

/    I shall speak or howl for myself,      |  intentionaly blank)	/


/           and no one else!  		    |				/


GCS d-- -p+ c+++(++++) l+++ u+(++) e+(*) m+ s++/- n-(---) h--(*) f+ g+
                       w+(++) t++(+++) r+ y+