AnsweredAssumed Answered

Account Privileges

Question asked by TKnTexas on Jun 6, 2009
Latest reply on Jun 8, 2009 by robe

Title

Account Privileges

Post

I have created a run-time for managing all of the utility accounts for our division.  There are just over 500 records for active utilities.  These are the tables:

 

* Utilities

* AP_Batch

* AP_Invoices

* AP_Invoice_Details

* Locations

 

These are all related in one form or another.   On a weekly basis I enter all utility invoices received for the week.  There is one batch record per week.  I do the data entry for the invoices directly in AP_Invoices.  I do the entry of the AP_Invoices_Details through a portal.  I can view the invoices from the batch record via a portal.  

 

I do not allow deletion of child records if the parent is deleted.  I know that is a little sloppy for data integrity, but it is necessary.  I don't ever want to delete records in Locations, Utilities or AP_Batch.  During the course of data entry,  I delete AP_Invoice_Details, or sometimes AP_Invoices.  I don't want to lose that function. 

 

How can I prevent deletion of records in Locations, Utilities, or AP_Batch?  It seems that account privileges will prevent deletions, but it is an all or nothing.  Any work-arounds?

 

Outcomes