Re: master/detail type control not working with filter.. please help ASAP

davidair — Tue, 05 Jun 2007 16:40:50 GMT

Well, I'm glad you have found a workaround! :)

Re: master/detail type control not working with filter.. please help ASAP

erinselena — Tue, 05 Jun 2007 13:01:07 GMT

Thanks so much for you responses, we were losing a lot of time on this so i simply changed the schema, i took the def section out of the assetinspections section and created a link between the two and things are working now. It is a bit of a complex scenario and if you are interested in still taking a look at the form let me know and you are welcome to but this works!

Thanks,

Erin

Re: master/detail type control not working with filter.. please help ASAP

davidair — Mon, 04 Jun 2007 21:32:02 GMT

You have a pretty complex scenario so it's be best if it was possible for you to share out the solution XSN. Just make sure that the issue still reproduces without the rest of the winform code.

To attach a file, simply clik on "files" on the top of the forum, go to "Uploads", "Community Uploads" and upload your form there.

Re: master/detail type control not working with filter.. please help ASAP

erinselena — Mon, 04 Jun 2007 18:16:46 GMT

I can send you my form however it embedded in a windows application and there is a lot of custom development behind it parts of it may not work.. I'll try to explain my scenario again...if you wnat me to send you my form so you can see it please tell me how to do so i don't know how to attach to this...

THere are 2 tabs on my form (Identify and Evaulate)

On the first tab (identify) there is a drop down box in a master/detail control - the user can choose many different items on this tab and fill out the information. Once the user has selected something they can navigate to the Evaluate tab, on this tab there is a drop down box whose datasource is coming from the forms datasource itself (basically it's being filled by all of the choices that were selected on the first tab) Also on this evaluate tab there is a repeating table that contains more information for the selections that were made on the first tab (i'll show a diagram of the xml shortly). so i want the repeating table data to be the records that are attached to the id of the drop down box so initially when i am on that page it is empty and i have to add the detail, so i add the detail but it isn't getting stored with its proper record infopath is storing ALL values (regardless of the master value i choose out of the drop down box) in the very first node ALWAYS.

Here is the node i am talking about, everything in blue shows up on the first tab in a master detail section. Everything in red shows up on the second tab for now i just show the my:def_Name field but it's in a repeating table, i have a combobox on the second tab whose source comes from the ass_ID field in blue but it is not a true master /detail, just a field whose datasource is this field and a repeating table to show all of the my:def fields. So the user selects the ass_id from the combox and i want to add the my:def field values for that asset and i should be able to achieve this by using a filter so i filter the repeating table on the combox value = ass_ID .. but when i actually go to insert into the repeating table it inserts EVERY record regardless of what value my combox contains in the same node (the below nodes is repeating so there can be many and i want the right my:def fields to go into the right insepctedAsset node)... hope this makes sense....

<my:InspectedAsset>
          <my:ass_Name>Balconies</my:ass_Name>
          <my:ass_ID>{2CB808FE-C14D-48ED-88BC-A98DA98A1586}</my:ass_ID>
          <my:ass_InstanceID>802FE88B-98E8-409C-AD3F-DEE3896372FA</my:ass_InstanceID>
          <my:ass_Location_CONCAT />
          <my:AssetLocations>
            <my:AssetLocation>
              <my:ass_Loc_Type />
              <my:ass_Loc_Accuracy />
              <my:ass_Loc_Description />
              <my:ass_Loc_DistanceValue my:ass_Loc_DistanceUnits="" my:ass_Loc_DistanceAxisSpecifier="" />
            </my:AssetLocation>
          </my:AssetLocations>
          <my:ass_IsVisible>true</my:ass_IsVisible>
          <my:ass_Description />
          <my:AssetDimensions>
            <my:AssetDimension>
              <my:ass_Type_Dim>Length</my:ass_Type_Dim>
              <my:ass_Dim_Value my:ass_Dim_units="Sq.ft." xsi:nil="true" />
              <my:ass_Dim_Comments />
            </my:AssetDimension>
          </my:AssetDimensions>
          <my:Condition>
            <my:Deficiencies>
              <my:Deficiency>
                <my:def_Name />
                <my:def_ID />
                <my:def_InstanceID />
                <my:def_Location_CONCAT my:def_Orientation="" />
                <my:def_IsVisible>true</my:def_IsVisible>
                <my:def_Severity />
                <my:def_Priority />
                <my:def_IsSelected>false</my:def_IsSelected>
                <my:ImagesNo>0</my:ImagesNo>
                <my:AttachmentsNo>0</my:AttachmentsNo>
                <my:def_AssetInstanceId />
                <my:DeficiencyDimensions>
                  <my:DeficiencyDimension>
                    <my:def_Type_Dim />
                    <my:def_Dim_Value my:def_Dim_Units="" />
                    <my:def_Dim_Comments />
                  </my:DeficiencyDimension>
                </my:DeficiencyDimensions>
              </my:Deficiency>
            </my:Deficiencies>
          </my:Condition>
          <my:ImageNo>0</my:ImageNo>
          <my:AttachmentNo>0</my:AttachmentNo>
          <my:ass_isSelected />
          <my:GroupsNo>0</my:GroupsNo>
        </my:InspectedAsset>

Re: master/detail type control not working with filter.. please help ASAP

davidair — Mon, 04 Jun 2007 17:19:09 GMT

Do you think it would be possible for you to share out your form? I am not sure I understand what the problem is...

master/detail type control not working with filter.. please help ASAP

erinselena — Mon, 04 Jun 2007 15:53:21 GMT

Hello All,

This is a fairly urgent matter. I have a combobox that looks up its values from the forms datasource. I want to link this to a repeating table and i am doing so through the use of a filter however it's not working, basically the link isn't being created and i don't konw why... i have to be able to insert rows intot he table and the inserted row is not being inserted in the correct record, it gets inserted in the first node in the xml. Anyone know why this is happening or how i can make this set up work right??

Thanks!

General

Re: master/detail type control not working with filter.. please help ASAP

Re: master/detail type control not working with filter.. please help ASAP

Re: master/detail type control not working with filter.. please help ASAP

Re: master/detail type control not working with filter.. please help ASAP

Re: master/detail type control not working with filter.. please help ASAP

master/detail type control not working with filter.. please help ASAP