Database dillema

[Koreena]

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??

 

[DelJo63]

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

 

[Koreena]

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

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

 

[DelJo63]

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?

 

[Koreena]

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

 

[DelJo63]

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.