Skip to main content

Number of fields; also number of entries in a multiple select field

  • September 12, 2021
  • 1 reply
  • 12 views
M
Forum|alt.badge.img+13

Is there any limit to the number of fields in a base?

Also is there a limit to the number of entries that can be put in a Multiple Select field

(I am wanting to transfer (one at a time) some 80,000 records from a desktop database which has approximately 250 fields and in the process rethink how i want the information presented. Whether the finished layout will also have circa 250 fields i don’t know but what I don’t want to find as i progress that I have reached AT’s limit.)

tia

1 reply

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • September 12, 2021

There is a limit of 500 fields per table. I do not know the limit on the number of multiple select values. However, if you have so many that you are worried about limits, you may want to consider using a linked record field instead.

    Terms & ConditionsAccessibility statement