Newbie Questions

Re: Filter on Secondary Datasource

Hilary Stoupa — Mon, 21 Dec 2015 15:44:33 GMT

Mind attaching a copy of your template to a reply under the options tab?

Re: Filter on Secondary Datasource

visualstudioguy — Mon, 21 Dec 2015 04:53:01 GMT

Category table is not related to the Orders table, but to the Items table. :)

Re: Filter on Secondary Datasource

Hilary Stoupa — Fri, 18 Dec 2015 17:08:05 GMT

How does the Categories table relate to the Orders table? The CategoryID in the Items table?

Filter on Secondary Datasource

visualstudioguy — Thu, 10 Dec 2015 10:20:11 GMT

Hi guys, I am a newbie in InfoPath development. So here's my scenario. Two of my tables in Main Datasource are designed like this:
ITEMS Table: ItemID, CategoryID
ORDERS Table: OrderID, ProjectID, ItemID, Quantity

And one of my table in Secondary DataSource has this structure:
CATEGORIES Table: CategoryID, CategoryDescription

I was unable to add Category table to Main DataSource because there'll be an issue with the "Submit" action due to table relationships, that's why its on Secondary DataSource. My problem is in doing the filtering for the Orders table, I have to filter it using the CategoryDescription which is on Secondary Datasource. Thanks!