Hi,

I am just finishing up my application, and I have enabled pesimisstic
locking to prevent conflicts. I have 4 tables that are related like this:

----------- ----------- -----------
| Client | | Docket | | TimeEntry |
----------- ----------- -----------
| Firsname | | Docket# |>> | Docket# |
| Lastname | | Date | | | Date |
| Phone | | Closed | | | Time |
| ... | | ... | | | CostHr |
| SocialSec |>>| SocialSec | | | ... |
___________ ----------- | -----------
|
| -----------
| | Disburs |
| -----------
1 >> many >>| Docket# |
| Date |
| Amount |
| ... |
-----------

So multiple dockets can be attached to a client, and multiple
time/disbursement entries can be on a docket. I need to stop users
from being able to delete a docket while someone is working on a Time
Entry or Disbursement, or stop them from deleting a client while
someone is working on a docket.

I apologize if this is an sql question. I am not sure if this is
something IBObjects would handle, or whether I would have to impose
some relations the opposite direction to stop it?


Thanks in advance,

Jason S Gagnon