Database dillema

By Koreena ยท 5 replies
Jun 24, 2014
Post New Reply
  1. I'm trying to find a database to use for landscaping company. Basically my only problem so far has been finding one that will allow me to select individual records to use or export for reports. Any ideas??
  2. jobeard

    jobeard TS Ambassador Posts: 11,149   +985

    A database by itself only collects data and the inserts and selects have to be coded by someone.

    a) do you have DMBS experience?

    b) did you try the Access component of Office?

    I use Quickbooks for accounting and the reports I get are just fine for me and the IRS :)
  3. Koreena

    Koreena TS Rookie Topic Starter

    I have tried access :/ as well as filemaker pro and a few others. I am building a plant database so accounting software not really suitable
  4. jobeard

    jobeard TS Ambassador Posts: 11,149   +985

    Hmm; Quickbooks has an Item section wherein you can have
    an Item with one or more components and manage the inventory.

    Filemaker is neat - - what didn't work for you?
  5. Koreena

    Koreena TS Rookie Topic Starter

    Having it let me search inventory of records and allow me to pick individual records to make a report from
  6. jobeard

    jobeard TS Ambassador Posts: 11,149   +985

    Hmm; I did this years ago for my wife with FM. The trick (for all database systems) is to form the query correctly so the result IS the list of items to be printed.

    If you need to select random pieces from the first query then
    a) the original query wasn't specific enough OR
    b) the tables did not have sufficient items to use as qualifiers in the query.

    As I recall, what is known as an SQL JOIN is not easy in FM.

    Suggest you find the Filemaker forum and ask how to get the report you need.
    FM will be (imo) the most direct and easiest to learn, master and to get your reports.

Similar Topics

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...