On Fri, Mar 17, 2006 at 10:33:18 +0100,
Kai Hessing <[EMAIL PROTECTED]> wrote:
>
> OK, it is really a little bit odd. I try to explain what should be done.
> I have 1:n connection between stud and phon (One student does have
> different phonenumbers, fax, eMails, etc...). A positive status means
Bruno Wolff III wrote:
> On Thu, Mar 16, 2006 at 18:11:33 +0100,
> Kai Hessing <[EMAIL PROTECTED]> wrote:
>>
>> The 'status'-row can contain either 1 or -1 and -4. And now I would like
>> to implement the action that if the the status field in the master table
>> for a special sid is changed, al
On Thu, Mar 16, 2006 at 18:11:33 +0100,
Kai Hessing <[EMAIL PROTECTED]> wrote:
>
> The 'status'-row can contain either 1 or -1 and -4. And now I would like
> to implement the action that if the the status field in the master table
> for a special sid is changed, all status-fields in phon for ent
Hi Folks,
I'm not perfekt in SQL so I'm not really sure, how this can be done.
I have a master table stud containing (amongs others) two rows called
'sid' and 'status'. Now I have different tables using constraints to
reference this table. For example I have one table called phon with the
rows 'p
