please i need help
i'm new with designer
i make a module using designer 10g
i have two items
item1 is employee salary
i want to make item 2 synchronize with item 1
I know it is very easy when using forms builder
but i do not know how to make it in designer
I think you'll need to be clearer about what you are trying to do. I take it that when employee salary changes, something else needs to change too. I also think that you are probably using the Forms Generator. But beyond that, you haven't provided enough information for a good answer.
I use the Web PL/SQL generator, not the Forms generator, so I'm not totally sure that this will work for you, but this is easy to do. When you define the unbound item, define it as a SQL Expression. Then use whatever function that will fill the unbound item the way you want. For instance, I have bound items NAME_FIRST, NAME_MIDDLE, and NAME_LAST, and want to create an unbound item to display them as a single string. So my SQL Expression is
NAME_FIRST||' '||NAME_MIDDLE||' '||NAME_LAST
You can even use a DECODE function or a CASE expression if you need some logic.
My unbound happens to be display only. It can be made updatable, but that WOULD require a trigger to do something with the data, like update a bound item - no way around it.