Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013
    Posts
    3

    Unanswered: Which tools to use? All have problems I can't resolve (yet)

    I am building a Product Management system, well trying...

    Tools Available:
    - 2010 SharePoint Online: I'm pretty good with forms and list setup
    - MS Access: I'm ok with form and query basics. Relationship setup.
    - MySQL Workbench: It's available to house data, but I am totally clueless

    Tool Requirements:
    Accessible worldwide to on-network employees using SharePoint or some kind of web interface (PHP?)

    Allow over 5000 part numbers
    - SP Online 2010 has 5000 row limit which I can't adjust.

    Allow Parent-Child relationships (many to many)
    - For any given part number (Column-1) I may need to assign numerous Part Numbers to a "Where Used" Column-C (SP need diff list, Access can query same table).

    Allow query & submit with various tables/lists
    - SharePoint/InfoPath only submits to one list
    - MS Access can submit to multiple, but user access/aesthetics/Coding are issues.


    What combination of tools should I pursue as a newb?
    Store Data: SQL, MS Access, or SP List? I don't think batch updates will work for this project.

    The Connections: SP list "Lookup", InfoPath, MS Access, or other?

    To Access/Submit changes: InfoPath form, MS Access Form, PHP, other?

  2. #2
    Join Date
    Jun 2013
    Posts
    3
    Quote Originally Posted by Poagman View Post
    What combination of tools should I pursue as a newb?
    Store Data: SQL, MS Access, or SP List? I don't think batch updates will work for this project.

    The Connections: SP list "Lookup", InfoPath, MS Access, or other?

    To Access/Submit changes: InfoPath form, MS Access Form, PHP, other?
    Looked into "Microsoft Business Connectivity Services"
    Will this tool allow me to setup lists in an Access DB saved to SharePoint with needed relationships/queries and then allow SP 2010's BCS to send & receive via an InfoPath form?

    It "seems" that this may let a network accessible InfoPath form send & receive from multiple tables in an Access DB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •