Obtaining a field value from a selected document in an embedded view

Posted on 2005-04-28
Last Modified: 2013-12-18
I have a form called category that contains a single field for a category value.

I have a category view that uses the category form and shows the category field value in the first column ascending.

I have an Product form that contains a field to hold the category value along with additional information about the product. The category view is embedded on this form.

I want to be able to single click the embedded category view and obtain the category field value of the document selected to modify a value on the Product form.  I looked at embedded editors but they change the value of the form used in the link and I don’t know how to get a handle on the Product form from the embedded category form.

I know (without embedding anything) I could use:

choice:=@UpperCase(@PickList( [Custom] : [Single] ; @DbName ; "Categories" ; "Select a category" ; "Please select a category for this new Item Master Entry" ; 1 ));

FIELD ProductCategory := choice;

But I want to avoid using picklist popups and input boxes to gather the information.

Thank you in advance for your help
Question by:fledav01
    LVL 46

    Expert Comment

    by:Sjef Bosman
    My guess: impossible. But I can't quite visualize what your goal is. Single clicking something ans still updating a Product? Usually, you open a Product document and you select a category. What's the general idea?
    LVL 15

    Expert Comment

    R6 ?  Then you can show the action bar in your embedded view (I think - must check - too lazy right now).

    You can try anyway to put the action on the Form that holds the view

    What will work for sure (again, R6 only) is to make your embedded view and Editable view (because I'm using that myself).   Let us know if you use R6, then I'll post an example.




    Author Comment

    Thank you for the responses so far.  Yes I am using R6 and the app is for the client.

    Perhaps it would be clearer if I explained it this way.  In VB you can dxrag a datasource control to the form and then map the column values to fields on the same form.  When the app is run clicking on an item in the datasource control updates the fields on the form.  Is that clearer?

    Thanks again for your help so far.

    LVL 2

    Expert Comment

    Use a listbox field, not an embedded view.  Your Choices formula will be


    That's all!
    LVL 2

    Expert Comment

    By the way, the ProductCategory field will be the field you turn into a listbox.

    See - it's easier than VB.

    Author Comment

    I accomplished it with frames - put the form in one frame and specified that as the target for links from the frame that contains the embedded view.  Thanks for all the input.  Can I give myself the points?

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
    Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now