TechSpot

Database dillema

By Koreena
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: 13,407   +314

    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: 13,407   +314

    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: 13,407   +314

    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.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.