Master/Detail setup not working... PLEASE HELP ASAP - InfoPath Dev
in

InfoPath Dev

Master/Detail setup not working... PLEASE HELP ASAP

Last post 05-30-2007 07:04 AM by erinselena. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 05-29-2007 07:15 AM

    Master/Detail setup not working... PLEASE HELP ASAP

    Hello Everyone,

    I have a release of my form going out in the next 2 days and I have something strange going on that i can't seem to fix. Please keep in mind i am using infopath 2007 and also hosting in windows app using formControl

    I have a form with 2 views, the first view has a repeating table on it and it shows items we call "Assets". on the second view i have a repeating table showing items called "Deficiencies". The schema is below for you to look at: Basically there is one asset and the asset can have many deficiencies... the my:Deficiency field is repeating.

     So what i want to do is the following: On the first view i have a checkbox labelled isSelected, when it is selected and you go to the detail view i only want to show the "deficiencies" that belong to this asset and i want to be able to add more than one deficiency to an asset. So what i do is i put the value that is in my:ass_InstanceID into a temp field and then i have a rule on my repeating table that says show all rows where my:ass_InstanceID = tempfield

    This is only working for the very first deficiency in the repeating group, all of the other deficiencies show up all of the time... what am i doing wrong?????

    Thanks so much for your help!!!!

    Erin
     

    <my:InspectedAssets>
            <my:InspectedAsset>
              <my:ass_Name>Awning</my:ass_Name>
              <my:ass_ID>{628FDC15-818F-40DF-8F5A-AEC51E2C3E3B}</my:ass_ID>
              <my:ass_InstanceID>4D293162-03B2-41E1-A819-071D840643B8</my:ass_InstanceID>
              <my:ass_IsVisible>true</my:ass_IsVisible>
              <my:ass_isSelected>yes</my:ass_isSelected>
              <my:Condition>
                <my:Deficiencies>
                  <my:Deficiency>
                    <my:def_Name>Broken Connection</my:def_Name>
                    <my:def_ID>{4D41B2B0-FE8E-4626-A359-8945B88FC94D}</my:def_ID>
                    <my:def_InstanceID>0C4B8029-51B5-4822-B738-0A9E2E60F10C</my:def_InstanceID>
                    <my:def_IsSelected>false</my:def_IsSelected>
                    <my:ImagesNo>0</my:ImagesNo>
                    <my:AttachmentsNo>0</my:AttachmentsNo>
                  </my:Deficiency>
                  <my:Deficiency>
                    <my:def_Name>Beam Damage</my:def_Name>
                    <my:def_ID>{B9170B9F-F1CC-4D2D-BC88-945A77598656}</my:def_ID>
                    <my:def_InstanceID>C1B90475-9D6D-4E8D-8FF3-98F3D9F2106C</my:def_InstanceID>
                    <my:def_IsSelected>false</my:def_IsSelected>
                    <my:ImagesNo>0</my:ImagesNo>
                    <my:AttachmentsNo>0</my:AttachmentsNo>
                  </my:Deficiency>
                </my:Deficiencies>
              </my:Condition>
            </my:InspectedAsset>
            <my:InspectedAsset>

  • 05-29-2007 12:48 PM In reply to

    Re: Master/Detail setup not working... PLEASE HELP ASAP

    Hi erinselena,

     Why are you using a tempfield, why don't you just hide all Assets where IsSelected = false.  This seems like it would be pretty easy - how exactly are you hiding the sections? You said a rule, but did you mean to say conditional formatting or filtering?  Filtering is prefered, since InfoPath never even retrieves the nodes before trying to render them.

    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 05-29-2007 01:48 PM In reply to

    Re: Master/Detail setup not working... PLEASE HELP ASAP

    Thanks for your reply!! now i have a new problem and it's a wicked one!!

    so i got this working but using the temp field, i filter the data saying the ass_InstanceID = tempField and this seems to work but it's wonky.. the thing about your solution is that it isn't based on the isSelected field anymore, i have a dropdown box whose datasource is a value in the forms datasource and it works however when i add deficiencies sometimes (and not all the time) the deficiency is added to the wrong asset adn i don't know why.

     

    basically what i do is when the dropdown box selected index changes i populate the temp field with the asset_InstanceID and then filter the data that shows up in the detail based on this.. does this sound like the right thing to do ? What's going on.. it's driving me crazy? Maybe the rule isn't working properly??
     

  • 05-30-2007 07:04 AM In reply to

    Re: Master/Detail setup not working... PLEASE HELP ASAP

    Doesn't anyone know what's going on here? ANY suggestions will help!
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.