Auto populate field1 based on the drop down menu in field2 - InfoPath Dev
in

InfoPath Dev

Auto populate field1 based on the drop down menu in field2

Last post 06-14-2011 08:34 AM by jbegic. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next

  • 06-06-2011 10:51 AM

    • jbegic
    • Not Ranked
      Male
    • Joined on 06-06-2011
    • Cupertino California
    • Posts 14

    Auto populate field1 based on the drop down menu in field2

    Reply Contact
    I have been trying and looking for an answer on this for the past few days and this is my last resort. Here is the problem:I have Repeating Table group called “SupplierRequest” which contains “SupplierPartNumber” and “SupplierModel” fields. This Repeating Table will be used by requestor to populate fields based on availability.I have another Repeating Table group called “DVTBuild” which contains “DVTPartNumber” and “DVTModelNumber” and some other required fields like quantity, needed by etc. This Repeating Table will be used by Project Managers to fill in their needs as of how many they need by when and to what location to ship to…etc. What I am looking for is:#1 - to have drop down menu in field “DVTPartNumber” that is pointing to “SupplierPartNumber”. This part is created and working (/my:myFields/my:Builds/my:SupplierRequest/my:SuppliersPartNumber).

    Anytime requester inserts an item in “SupplierRequest” field, that same item will also show up under drop down menu in “DVTPartNumber”.

     

     #2 and this is where I am stuck– to auto-populate “DVTModelNumber” when I select an item from “DVTPartNumber”. This DVTModelNumber should be the same as in “SuplierModel” under the same “SuplierPartNumber”. I hope this makes sense and I HOPE there is someone out there that can help.

     

    Thank you,JBegic 

     

    Thank You
    JBegic

  • 06-13-2011 11:43 AM In reply to

    Re: Auto populate field1 based on the drop down menu in field2

    Mark as Answer
    Reply Contact

     Using a rule to Set a field's value and some filtering, #2 should be possible, but it'll take some playing around to get it right. If you want to attach your form, I can take a look.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 06-13-2011 12:44 PM In reply to

    • jbegic
    • Not Ranked
      Male
    • Joined on 06-06-2011
    • Cupertino California
    • Posts 14

    Re: Auto populate field1 based on the drop down menu in field2

    Request.xsn
    Mark as Answer
    Reply Contact

    Thank You Ernesto... File attached?

    Thank You
    JBegic

  • 06-14-2011 07:08 AM In reply to

    Re: Auto populate field1 based on the drop down menu in field2

    Request.xsn
    Mark as Answer
    Reply Contact

    Attached. I added one rule to the dropdown and tested to make sure it works. Please review the rule and let us know if you have any questions. Thanks.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 06-14-2011 08:34 AM In reply to

    • jbegic
    • Not Ranked
      Male
    • Joined on 06-06-2011
    • Cupertino California
    • Posts 14

    Re: Auto populate field1 based on the drop down menu in field2

    Mark as Answer
    Reply Contact
    This is AWESOME Thank you very much Ernesto... You are the SAVIOR
    Thank You
    JBegic
Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.