I've got a scenario in my database whereby the existence of a record in one table SHOULD depend on the existence of another record in another table...e.g When i create a record in 'Table A' i currently create a related record into 'Table B'. I do this because i know that the system needs this record for other events that will take place around the website....the problem is that i know this cause i developed the system, any other DB administrator wouldn't have a clue that this relationship needed to exist...is this a business rule that is needed? Is this where i would use a trigger???
Thanks in advance