Forms 4.5: Is this possible without procedure?

[leburs]

Hello,

Does somebody know if it's possible to do in Forms 4.5 the following:
On the left part of the screen we should see the list of people ordered by Last name. Last names come from a view (not-updateable, Oracle 7). On the right part against each person we should see a row of his details which come from a table. Details have to be inserted/updated. I made the right part in a based-table block, since the where_clause on this screen depends only on the details in the right part. In POST-QUERY I retrieve then the list of last names - but it's already cannot be ordered_by !
What is the easiest way to do this?
Or I shouldn't make this block table-based?

Thanks!

 

[freedomUSA]

Have you solved this yet? I am not sure that I'm reading this right. Is there a 1:1 between the two sides of the form? On the block properties under database there is an order by clause. Won't work so well if it is not 1:1.

Is the last name included in that base table? How come you have to have the view instead of just changing the last name field to non-enterable (if it is in the base table)?

Otherwise, What link do you have?

 

[leburs]

I've solved it not basing on table. Unfortunately, last name is not included in "main" base table which contains details, linked by person id. It's not necessarily 1:1, it's possible to see same Last name several times, if it has many detail rows.

 

[freedomUSA]

Glad you solved your problem.