Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

should I use repeating field ?

irenelam
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

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?

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]

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

Create an account or sign in to comment

https://fmforums.com/topic/2873-should-i-use-repeating-field/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.