05-18-2016 11:14 AM
I believe the size limitation using SQL Express is 10 g bytes. There's no specific limitation to the number of added fields though an excessive number of fields can cause problems with the layout. If fields are being added to accommodate a one-ro-many situation if would be better to use a custom table rather than adding a large number of fields.
05-19-2016 09:24 AM
How do you add a custom table? Is that something I would have ACT do, or is it something that can be done by the user?
I believe we are adding too many fields. I've been creating different layouts for the different type of customers.
05-20-2016 01:55 AM
To add tables you will need an act add-on unless you are a wizz with ACT sdk.
With the SQL based version of ACT the number of fields should not be an issue as I have a client that added around 500 fields but would challenge if this is ever a good idea as no one is going to spend all day filling them in.