locked
Create Query Across Table on a popup RRS feed

  • Question

  • <p><img alt="Sql Scheme" src="https://social.msdn.microsoft.com/Forums/getfile/660160" /><img alt="PopUp" src="https://social.msdn.microsoft.com/Forums/getfile/660163" /></p>

    Hi Guys,

    I have made some simple Screenshots to explain my problem. Hopefully I could get my point Across. The Screen is Based on Detall Horas Table. I need to Create a Filter on the popup When employees want to enter their Weekly Details. where they could have a filtered view of their Projects Which is in the Proyectos_Asignados Table Linked to Employee Table and Proyectos Table. Employees LoggedIn with thier Windows Username, are in Employee Table.

    Param Singh

    • Edited by Angie Xu Friday, May 29, 2015 7:18 AM text edit
    Friday, May 22, 2015 7:30 AM

All replies

  • Hi Param,

    >>where they could have a filtered view of their Projects Which is in the Proyectos_Asignados Table Linked to Employee Table and Proyectos Table

    You can create the filter screen based on projects screen, and set the filter condition.

    With regards,

    Angie


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, May 29, 2015 9:39 AM
  • Hi Angie,

    Thanks for your Kind Reply, But am not able to follow it poperly or am missing something.

    I want to make a query something like,  

    from Detalle Screen( Table) Where Proyectos = Where( Proyectos Asignados.cod Empleado = me.application.user.name)

    I hope could put it across.

    I just want that only Proyectos appear from Proyect (TABLE)which are assigned to the Present user( proyectos Asignados.cod empleado = employedos.user name ).

    Please, Try to find me a solution.

    Param singh

    Monday, June 1, 2015 10:21 AM