This content has been marked as final. Show 4 replies
i wonder why not used the relationship between 2 tables & id used as pk in streets table & fk in ur current data block !!?
I understand what you say but partially.. please explain in more detail how to do that;
How should look the adrese_nezonate block, then? I have to add a 'name' column and set copy value from item property to 'STREETS.NAME', and database_property No?
Then the post-query trigger how should look like (the order by clause)? The post-query sends the entire query (with where/order by clauses) to the server, but in that "select... where... order by" (built dynamically) there are only columns from that block (adrese_nezonate). I need to join with streets, INSIDE that query.
Got it. This helped me: http://www.oracle.com/technetwork/developer-tools/forms/documentation/blockonajoin-131860.pdf (if helpful for someone else).
Roger how helpful r u !!! :)
Now it's clear u could crested non database block as a master to enter dept with LOV for the detail Will be based on a database view then u create a relationship between the two blocks.