One Browse to Many Forms

[Alberto]

Hi,
I have a browse that need to maintain many different forms over many differents tables.
The main browse table has only ID, DATE, FORM_TYPE AND FORM_ID.

When the user see the browse I display the DATE, FORM_TYPE and a memo build dynamically depending on the FORM_TYPE and reading the form table with the FORM_ID.

My problems are:

When the user press the Insert Button:

I need to ask for "what form type to add" and redirect to that form.
For that I´m using the main table form asking for the date, selecting the form type with a drop and pressing a button to redirect to the appropiate form.
Q1: Is there any way to redirect directly from the Drop?
Q2: An if it´s not, how can I change the button hyperlink dinamically?
Q3: Can I use a drop in the main table using EIP defining the form type and redirecting to the appropiate form when the insert is done?

When the user press the Change button:

I need to redirect to the appropiate form type.
Q1: How can I redirect to the appropiate form in the "change" browse button?

Any other ideas of how to manage this scenario will be very much appreciate.

THanks
Alberto

[Bruce]

Hi Alberto,

I would not include any Insert or Change buttons on the browse.

Rather, on the browse row, I'd add 2 "other" buttons. One to do an insert, and one to do a change. You'll need to set the URL as per FAQ W4.

Cheers
Bruce