locked
Filter with relation tables RRS feed

  • Question

  • Example, I have 3 tables: TableA, TableB and TableC.

    I can filter TableA by customerID, but how can I filter TableB by TableA primary key, and TableC with TableB primary key.

    Can anybody show me a example for this case.

    Thank you.

    Thursday, November 25, 2010 5:33 AM

Answers

All replies

  • There was a lot of discussion about this topic in other threads: JOIN-based filtering in v3? and Syncing related tables
    • Proposed as answer by M.Bi Thursday, November 25, 2010 7:45 AM
    • Marked as answer by mjayaram Thursday, November 25, 2010 8:50 PM
    Thursday, November 25, 2010 7:43 AM
  • Thank Mr.Bi.

    I will look these threads, and will close this answer after I finished my aspect.

    Thank you.

    Thursday, November 25, 2010 8:48 AM
  • I read these threads, I notice that It's just a ways to work around and I can not use this :(.

    Hope fully in 4.0 CTP we have a better way.

    Thank you.

    Thursday, November 25, 2010 9:41 AM
  • As you can see in the other threads, many people are asking for this feature. We all hope MSFT will add this capability to SyncFX some day. Until then you will have to stick with one of the suggested workarrounds.
    Thursday, November 25, 2010 11:07 AM
  • Thank M.Bi.

    I'll continue on that and still wait for best solution :)

    • Marked as answer by BruceDo Friday, November 26, 2010 1:55 AM
    Friday, November 26, 2010 1:55 AM