should I use repeating field ?

[irenelam]

My database has 200-300 records, each record will have several fields which I like to define as "repeating field". Problem is, the no. of repeats in each of these fields varies, some may have a few,and some could be several dozens. I would also like to run a query eventually to determine how many of these repeating fields in each of the record is not empty. Is there a quick way to set up this query? Or should I not use repeating field at all? What is the best way to design this databse? set up related files?

[Kurt Knippel]

quote:

---

Originally posted by iyee:

My database has 200-300 records, each record will have several fields which I like to define as "repeating field". Problem is, the no. of repeats in each of these fields varies, some may have a few,and some could be several dozens. I would also like to run a query eventually to determine how many of these repeating fields in each of the record is not empty. Is there a quick way to set up this query? Or should I not use repeating field at all? What is the best way to design this databse? set up related files?

---

USE RELATED FILES. This is what a relational database is all about. Do not use repeating fields, except in the most dire of circumstances.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=