Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


populating list items from text items in D2k

Posted on 2003-03-18
Medium Priority
Last Modified: 2007-12-19
I have the following problem when working with forms in D2k.  See if anyone could help me out:

I have a data block in my form named ?block1?.  The fields are

-     Emp_code - varchar2 Text item, Emp_name - varchar2 Text item and Pf_number - varchar2 Text item.

Here, Emp_code in block1 is a primary key  is generated in sequence by means of a trigger.  This trigger, I have written and is successful.

I have another datablock in the same form named ?block2?.  The fields are

-     Emp_code, varchar2 List item, Emp_name, varchar2 Text item and ESI_number, number Text item.

Now, I want to implement the following functionality:

Whenever I add new items to Emp_code (Text item) in block1, it should be added to the list for Emp_code (list item) in block2, so that user will pick it whenever he needs to fill up Emp_code in block2.

Can any one give me the trigger coding for this?

Question by:srigupta
  • 2
LVL 22

Expert Comment

by:Helena Marková
ID: 8165482
I think that you can use a When-New-Block-Instance trigger of block2 and use POPULATE_LIST built-in there. If you dont't want to populate list item each time then you can add a non-displayed item to the block1 and in a Post-Insert trigger of block1 set it and test its value before populating the list item. After populating the list item you can reset it.

Author Comment

ID: 8195726

I am quite convenient with the positioning of the trigger coding.  that is not a problem?

But, I need to know what should be the exact trigger coding?  because, I tried to populate a record group and transfer it to the list item,  but it does not work out.  Try and see!
LVL 22

Expert Comment

by:Helena Marková
ID: 8200810
I think that it would be better if you post here your code for populating a record group and transfering it to the list item.

Accepted Solution

SpideyMod earned 0 total points
ID: 8861273
Administrative Action - PAQ'd and points NOT refunded.

Community Support Moderator @Experts Exchange

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question