clivemas Posted February 2, 2008 Share Posted February 2, 2008 I am trying to find a way to disallow the creation of new record(addition of a new row) in a portal after a certain date (year end) in a invoice /Invoice Line Items database. Ideally if the “allow the creation of records in this table†option in Define Database could be conditionally turned on/off depending on the date of the invoice, it would solve my problem. Or a way to “freeze†parent records and their child records for past year invoices. I tried custom privileges, but there is no conditional creation of records, it is either yes or no. Link to comment Share on other sites More sharing options...
HBMarlowe Posted February 3, 2008 Share Posted February 3, 2008 I don't know of any way to stop the creation of records that would still permit you to view existing records in the portal. Have you considered scripting the creation of records, rather than allowing creation via the relationship? It would be easy to prevent the script from executing after a certain date (or under other conditions). Link to comment Share on other sites More sharing options...
clivemas Posted February 3, 2008 Author Share Posted February 3, 2008 Thanks HBMarlowe; I'll use a script. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts