Recently, I added constraints to many of my tables to prevent users from leaving important dates, dollars, and quantities blank (not null constraint). Although I can do this in forms, they have access to these same tables using browse/edit.
But... I noticed that at a customer this week, a table which had a file 2 size of 12mb and file 3 size of 8mb, jumped to 17mb for file 3 after the constraints where added??!!! This doesn't seem like very good design. Any suggestions? TIA, Dennis ***** Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Fax: 570 775-9797 ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
