Securing customers

Kisu

Hmm I have another question

It looks like that all of my companies use the same Customer Timetable.

In other words when I add new Customer to one of my companies it shows up on every other companies I have.

This causes a little problem, there is a possibility that I could erase Customer that has a journal entry from by other company. :?

How could I protect this so no customers could be eraser from other companies if they have or dont have journal entries even? :-k

nunomaia

Some companies activate the property of data per company to “no” of some master tables, I ‘m not very supporter of that method.

You can make a change in delete trigger of customer table. Every time a user tries to delete a record, goes to all companies and check if it has entries.