Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database Table Capacity Issue

Copper Contributor
Posts: 22
Country: USA

Database Table Capacity Issue

[ Edited ]

So I am having trouble adding more drop down select fields to the database. I can add plenty of character fields, but if I try to make it a drop down character field I get this message.

 

"Combined field lenghts have exceeded the maximum for the database table."

 

I could use some help with the following as I'll need to start work on a new tab for 2016 year tracking.

 

What is the table size?

 

What field tpyes fall into it?

 

Is there a way to increase the table size?

 

Anything else that would be helpful to know.

 

 

Error Message Crop.jpg

Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: Database Table Capacity Issue


jamac wrote:

 

What is the table size?

     The table size is set by SQL.

 

What field types fall into it?

     All types, also the contact table is comprised of several linked SQL tables

 

Is there a way to increase the table size?

     No

 

Anything else that would be helpful to know.

     From what you stated in your message, it sounds like you are using multiple sets of database fields as a substitute for a one-to-many table. You need to investigate adding a custom table to your database.

 

 


 

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129