Bringing Data without having relationship between tables. RRS feed

  • Question

  • Hi All,

    I got a scenario where there are 2 tables A, B.  There is no relationship exist in between the two tables. Is it possible to bring Table A column data in the Table B Screen. 

    Table A : A_ID, A_Description           Table B : B_ID, B_Description

    I have another Table C which is like a Link Table between Table A and B. 

    Table C : A_ID, B_ID, Description

    Using these tables and structures, is it possible to display Table A column data in Table B ???

    Tuesday, January 29, 2013 2:08 AM

All replies

  • You have a many-to-many relationship between Table A & Table B, using Table C as a "bridge" table.

    If you want the value to be displayed on a screen, you should base your screen on Table C, then use Add, Other Screen data to pull in values from the A & B tables.

    You can type in the path to the property you want displayed (intellisense will help).

    For a value in Table C, you can Add: Description.

    For a value in Table A, you could Add Other Screen DataTableA.SomeProperty.SomeValue

    For a value in Table B, you could Add Other Screen DataTableB.SomeProperty.SomeValue

    Yann - LightSwitch Central - Click here for FREE Themes, Controls, Types and Commands
    Please click "Mark as Answer" if a reply answers your question. Please click "Vote as Helpful" , if you find a reply helpful.
    By doing this you'll help others to find answers faster.

    Tuesday, January 29, 2013 4:43 AM