RBarryYoung (5/10/2009)

---

Yes, I agree with Paul's idea. Use normal constraints to ensure that children always have parents, then use the stored procedures code logic to insure that a parent...

thank guys, and if I ask really nicely would you have a little example of this chicken and egg problem for MS SQL? or is that pushing it 🙂

that sound interesting, now all I need is a code example and I'll be flying, after 3 days of searching book and the net I cant find one, at not...

Yeah, I'm learning that what I need to do is use INITIALLY DEFERRED key words and set the option wait for commit to on before so that the check constraint...

ah OK I see. thank again. Asta

You now what Gail I think you have me convinced. I can just add a reminder message like you said at the interface end. I've been silly. ...

I see, I I want the constraint or other method to not allow the user to close the database not at least without warning message. so the message should...

hmmm interesting, but getdate() will return now, the user will need to enter date and time which is not real time. they might enter the date and time the...

Thank you,

I had thought of doing that, but then it is possible for them just to enter the date part of the field leaving the time part to default to...

Hi

Thank you for all your help, I have attached a word document that shows all the queries and the two tables used in the queries + showed which fields are...