Hi... could you help a newbie?

I exported a medical database from Excel to Filemaker for easier control of the information. All the fields and their types transferred fine.

I have successfully "found" records according to my requirements..

i.e.

Main DB: All patients

1st search: All patients with ICP codes 900-910

1st subsearch: all patients with those codes wearing seatbelts

2nd search: all patients with ICP codes 890-900

2nd subsearch: all patients with those codes brushing teeth.

and etc., etc.

My plan is to find these subgroups and add fields to them later as I gather more data. How can I do this? Everytime I "find" entries.., it does not allow me to save them as another database .. i.e. Patients with ICP codes 890-900.

I've read the tutorial and still can't figure this one out. Can someone please paint me some broad strokes?

Thanks!

Use the Save a Copy As command to save a copy of the database, then find the records you want, use the Show Ommitted Records command to "swap" the records around and delete the records you don't want.

Alternatively, use the Export command to export the found set of records.

I did do this before ... but it seemed so awkward to do. There is no better way?

How about by using the relational databases... or is that another headache.

I do have familiarity with MS Access and my plan was to have a original database and relate further subdivisions. Then as I entered data into these subdivisions they would also be added to the original database.

Thanks for the quick reply!

Find your needing records then export to other FM file.

Even you can wright script for automating your work.