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, ...