I have two table in the database environment with a relation set between them I have row buffering on one and table buffering on the other. With each of the tables I have a stored procedure in the database that check each table to check that certain fields are completed in each of the tables. The problem that I am having is that when I go to add a new record the stored procedure fires. On the clients table I append a new record which get an id from a stored procedure and then I insert into the orders table the id from the clients table plus it puts in an id also from the stored procedure. After some checking out I have discovered that the apparently the relation is causing me the problem. Would it be best to delete the relationship append the record and after I save reestablish the relationship. Thanks
Previous