form trigger

Navi_Learner

We don't have license to write trigger in the form. Right now I create a tabular type form and at the bottom, there are three button, OK, Cancel, Help. When I run the form, I can only view HELP button. Is it the only way to make OK and CANCEL button work if we use trigger? Any other way to make it work as we have no way?

DenSter

The OK and the Cancel buttons will appear automatically when the form is opened in Lookup mode.

Navi_Learner

Thanks! It seems that OK button doesn't work and it has no action. When I view the form, the only button I can see when running is HELP button. Then I change the property INVALIDACTIONAPPERANCE from HIDE to NORMAL. Though I can see the button when I run the form, but it doesn't work. How can I make it work? Thanks!

Navi_Learner

OK I got it! Thanks!

Navi_Learner

Another question. I create a form in which I create a menu button which retrieve another tabular form. But when I select one record from the tabular form using the menu button, I can't get it to the form. For example I select ID R10005 and click OK, I should see this record in the form. Why it doesn't work?

DenSter

Because you're probably not programming it correctly . Usually the way that forms are used as lookup forms is by setting the tabular form as the lookupformID in the table (lets say table A). Then set a table relation to the table A from table B. Then create a form that displays records from table B and add the field that relates to table A to the form. You will notice that without programming a single line of code, you will see the tabular form of table A, and that the OK and the Cancel buttons are both visible, and that the key value from table B is entered into the field in table A.

You are focused too much on trying to make the form work, and ou need to learn about tables first. Then you can utilize default table behaviour in forms and figure out how default form properties behave. The stuff that you are trying to do is really very easy when you have a properly designed database.

What you need to do is buy the development training material and study it. You could also start out with the application designer's guide if you can't spend the money.

garak

I hope i understand.

You have form A. ther you have a menu button. When you press the Menubutton its open Form B. When you select a record in Form B and press ok you will see the Record in Form A :?:
What would you do :?:

Navi_Learner

You are right Garak! But I can't see the record if I select the record from the menu list? Please advise!

Navi_Learner

Solved. Thanks!