Is it ok to use a list, that uses lookup columns to get its own data, as a secondary data source? - InfoPath Dev
in

InfoPath Dev

Is it ok to use a list, that uses lookup columns to get its own data, as a secondary data source?

Last post 11-30-2011 02:26 PM by Anson Hidajat. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 11-23-2011 06:23 PM

    Is it ok to use a list, that uses lookup columns to get its own data, as a secondary data source?

    Reply Contact
    Would having a secondary data source (which in this case is a SharePoint list ) that has a lookup column with another list SharePoint list a bad idea? Is it feasible to do so? Would this slow the performance of my InfoPath form as it will e pulling data from a list that is also pulling data from another list via a lookup column?

  • 11-30-2011 02:26 PM In reply to

    Re: Is it ok to use a list, that uses lookup columns to get its own data, as a secondary data source?

    Mark as Answer
    Reply Contact
    This seems like a perfectly good use of a secondary data source.  You will only start running into performance issues if your lookup list starts running into the thousands of items.  And if you need to support that much data in your lookup, you can mitigate any performance issues with filters.
    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.