Filter Data property not available to secondary data source

[ChrisM]

I have a repeating table bound to a secondary data source. The filter data
property off the Display tab is not available. If I add a repeating table
based upon the main data source the filter option is available.

I am trying to filter a repeating table based upon values in a drop down
list box.

Please help

 

[ChrisM]

Greg -

I will try that but also looking for your recommendation.

I have a main table and a detail table both in Access for additional
reporting. I have project main records and want to enter status for each
project each week. I want to select 1 record from the main table (i.e, list
box1) and then update a few text boxes with the main information based upon
this selection.

Then, I want to insert new records into the detail table but not the main
table. It is a one to many between the main and detail. How can I only
insert records into the detail table?

There is a clientID that is the key between the tables.

I can get each to work independently -
1. new records into detail when it is the main source but not update the
text fields to display the master record
2. Display the main record based upon list box selection but not insert a
new record into the detail

BUT NOT TOGETHER - any suggestions! This seems so simple... but obviously I
am missing something. Any help is appreciated.

 

[ChrisM]

Sometimes simplifying helps, I was making things too complex. OK - that
makes sense and I downloaded a couple of examples from Infopath dev but I
receive an error when setting the detail control (repeating section
propoerties). I am using an access database as the primary data source with a
master table and detail linked by ClientID.

When linking to master id on the detailed repeating section properties I
receive the following error "The master that you just picked is in an
incorrect context."

I find little to no reference on the MS site for this.

Thanks - I am sooo close!
-Christine

Forgive me if I'm over-simplifying my response...

If this is all in the main data source, it sounds like a job for a master/detail control. If these are secondary data sources, you cannot use this control.

Either way, you should be able to change a setting on the "main" table to not allow insert/delete, while still allowing it on the "detail" table.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Greg -

I will try that but also looking for your recommendation.

I have a main table and a detail table both in Access for additional
reporting. I have project main records and want to enter status for each
project each week. I want to select 1 record from the main table (i.e, list
box1) and then update a few text boxes with the main information based upon
this selection.

Then, I want to insert new records into the detail table but not the main
table. It is a one to many between the main and detail. How can I only
insert records into the detail table?

There is a clientID that is the key between the tables.

I can get each to work independently -
1. new records into detail when it is the main source but not update the
text fields to display the master record
2. Display the main record based upon list box selection but not insert a
new record into the detail

BUT NOT TOGETHER - any suggestions! This seems so simple... but obviously I
am missing something. Any help is appreciated.

Filtering is supported on secondary data sources *IF* you add it manually to the .xsl file. You can create the basic filtering on a main data source table, then copy it in Notepad to the secondary data source table, making the necessary adjustments to that the XPaths are correct.

Sorry... unfortunately in the current version, secondary data sources are second-class citizens and are missing much of the useful functionality we enjoy with the main data source.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



I have a repeating table bound to a secondary data source. The filter data
property off the Display tab is not available. If I add a repeating table
based upon the main data source the filter option is available.

I am trying to filter a repeating table based upon values in a drop down
list box.

Please help

 

[Martyn Lawson]

Hi Greg,

I know this is an old post, but i wondered if you could help me.

I have a repeating table on a secondary datasource that i would like to
filter. I have created this in a new form and looked at the .xsl file to see
the format and although it appears to work for one of my filter conditions, i
cannot get the other to work.

I have the line:
<xsl:for-each select="xdXDocument:GetDOM("Job
Bags")/dfs:myFields/dfs:dataFields/dfs:Job_Bags__Prototype_ [ (@Customer_Name
= ../my:myFields/my:customer/my:customerName and @Status = "Quote")]">

in the .xls file. I am trying to filter the rows where the Customer_Name
field in the secondary datasource matches the
my:myFields/my:customer/my:customerName field in the main datasource and also
where the Status is equal to Quote.

Adding this line to the .xsl file works fine if i am just filtering on the
Status field, but not when i try to add the customerName filter. I am
assuming that my xpath is incorrect. Can you please advise?

Cheers,
Martyn...

 

[James Butler]

Please someone answer this issue about the Master being in an incorrect
context. I'm having the same problem.
I place two repeating tables on a form making one the master and the other
the detail. When I try to make the other the detail I get that "in an
incorrect context error".

Please Help!!!
--
James Butler
Programmer/Analyst/DBA

Would someone from Microsoft like to approach this error message?

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Sometimes simplifying helps, I was making things too complex. OK - that
makes sense and I downloaded a couple of examples from Infopath dev but I
receive an error when setting the detail control (repeating section
propoerties). I am using an access database as the primary data source with a
master table and detail linked by ClientID.

When linking to master id on the detailed repeating section properties I
receive the following error "The master that you just picked is in an
incorrect context."

I find little to no reference on the MS site for this.

Thanks - I am sooo close!
-Christine

Forgive me if I'm over-simplifying my response...

If this is all in the main data source, it sounds like a job for a master/detail control. If these are secondary data sources, you cannot use this control.

Either way, you should be able to change a setting on the "main" table to not allow insert/delete, while still allowing it on the "detail" table.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



Greg -

I will try that but also looking for your recommendation.

I have a main table and a detail table both in Access for additional
reporting. I have project main records and want to enter status for each
project each week. I want to select 1 record from the main table (i.e, list
box1) and then update a few text boxes with the main information based upon
this selection.

Then, I want to insert new records into the detail table but not the main
table. It is a one to many between the main and detail. How can I only
insert records into the detail table?

There is a clientID that is the key between the tables.

I can get each to work independently -
1. new records into detail when it is the main source but not update the
text fields to display the master record
2. Display the main record based upon list box selection but not insert a
new record into the detail

BUT NOT TOGETHER - any suggestions! This seems so simple... but obviously I
am missing something. Any help is appreciated.

Filtering is supported on secondary data sources *IF* you add it manually to the .xsl file. You can create the basic filtering on a main data source table, then copy it in Notepad to the secondary data source table, making the necessary adjustments to that the XPaths are correct.

Sorry... unfortunately in the current version, secondary data sources are second-class citizens and are missing much of the useful functionality we enjoy with the main data source.

--
Greg Collins [InfoPath MVP]
Please visit: http://www.InfoPathDev.com



I have a repeating table bound to a secondary data source. The filter data
property off the Display tab is not available. If I add a repeating table
based upon the main data source the filter option is available.

I am trying to filter a repeating table based upon values in a drop down
list box.

Please help

 

[Makor]

I am using Version 2007 and was wondering if this problem still exists. Here
is my situation.

I have one form with a main data connection that updates transactions. I
have many other secondary datasources that all work fine with dropdowns and
filtering. For instance when I select a certain category in one drop down
only the products for that category are listed listed in dropdown 2. I need
this to work for a repeating table.

I have a text box above my repeating table that I want the user to enter in
a lot number. In my repeating table I only want to display the data that has
a corresponding lot number. This data can still be in the data source I just
don't want to display it to the end user.

There has to be away to accomplish this.

Please respond as soon as possible as this is a pressing issue and if we
cannot fix this we need to find another solution.

Thanks

If there is not solution can you please explain what the thought process
behind this was and maybe that will enlighten me to use another way.

or show me in more detail how to modify the xsl file in order to pretend
this is main datasource.

Thanks again.