how to add new line or record in form

hi

I am developing a video rental system using Developer 2000 trial version

I got a little problem

I create a rental transaction block "Rental" and a text item "Movie_#"

what I want is
when I enter movie # in text item and press enter forms go to table search movie with this # then go to rental block and create new line at the end of block or new record at the end of block and put fetched data into newly created record or line

I did everything except create or insert new record into rental block because my "When-validate-item" trigger give me an error "Illegal use of insert-record in When-validate-triger". I tried with add-new-record and all posible methods but I failed

could you please tell me how can I accomplish my task using developer 2000

I much appreiciate ur concern

Sincerely

Asif Received on Wed Nov 05 1997 - 00:00:00 CST