Question

  • Creator
    Topic
  • #2141064

    Database Options

    by kbohrer84 ·

    I am looking to find a database system where a user can input data in a “form” format and that data can be linked to other data so that when one thing is queried, anything that it’s linked to will be found. For instance, Item #10 is put in the system, and it’s linked to Service #16 & Service #19. When Item # 10 is searched, service #16 and #19 should be returned and vice versa when either service #16 or #19 is searched, item #10 should be returned. This seems like a simple feature for a database system, but I am very new and unfamiliar with creating something like this. Thank you!!

You are posting a reply to: Database Options

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

  • Author
    Replies
    • #2419762

      This is usually done by

      by rproffitt ·

      In reply to Database Options

      1. A database admin type person or
      2. A programmer.

      For beginning database users they usually end up with forms and reports as they learn enough to create their custom system.

      Sometimes the newest of the new want to have a complete system delivered to them by others. For that you look to Fiverr or Upwork until you have time to invest on your own.

    • #2419757

      Re: database

      by kees_b ·

      In reply to Database Options

      The database is to store the data, and the GUI is for the user to enter and retrieve it. It seems you are needing both.

      Long ago one used dBASE for such. Nowadays you can use MS Access, or – in simple cases – MS Excel (has forms, and vertical lookup for linkages). Or PHP/MySQL (or may more modern alternatives if) it has to be accessible via Internet.).

    • #2419754

      Database – Access

      by kbohrer84 ·

      In reply to Database Options

      So based on what you said, just to clarify, would Access work for my purposes? As mentioned, I want the user interface for data entry to be a form, and I also want the report that is returned to be in a form type format. Will that be possible with Access? I don’t need it to be accessible over the Internet, it just needs to be accessible for 100-150 employees on a local network. Thank you!!

      • #2419752

        At 100+ user access.

        by proffitt ·

        In reply to Database – Access

        No one I know would use Access. The usual system would be the usual combination of web server for the front end, some SQL Server (MySQL is very common) for the database work and for the back end, PHP and such.

        People that create such things are now widely available. Costs for the software for said server start at free with the usual LAMP or WAMP. Read https://en.wikipedia.org/wiki/LAMP_(software_bundle) As to the Internet think as that as your network.

        (Added with edit.) While the OS, server software and such is free, someone such as a programmer pulls it all together.

        Remember that this may be overload to the newer folk beginning such a project but it’s important to never make such in Excel or Access since this must work for over one hundred people. I’ve seen many disasters where someone didn’t know about scale and made a spreadsheet or Access solution and then they were fighting with either for years.

    • #2413320

      Databasr system

      by naxtre ·

      In reply to Database Options

      Redis the database can be used for the query asked.

Viewing 3 reply threads