InfoPath Dev

Hello, i have an extendable table and i'm displaying in a contact this contact contain a LookUp Field to another list named Organization so we have : Last Name, First name, Telephone, Email, Organization(LookUp) when i choose the LastName, the organization is filled automaticaly all the fields are displayed without problems except Organization wich is displaing ID's beside title of organization (1,2,3,etc..) how can i display the title ( i already tried to create a label (OrganizationTitle and query the Organization list to display the title where the ID = Organization) but that's not a solution because my table is extendable ( how can i get a label to every row added)? can you help me please? Thanks

Where are you retrieving the data for the org?  Is it from a SharePoint list? SQL database?

Sounds like what you need to do is to create another connection to the Org table and then do a filter on where the ID is equal to the lookup you have and then retrieve the title that way.

Hello, thnaks for your reply i'm retreiving the data from a sharepoint list named Organization, but creating another connection with organization list and filter it where the ID equal to the look up will not solve my problem because i have an extendable table, and i can't know how many rows the user will add ( i have to do a filter for every row?) Thanks for your help