Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Relationship between three tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Relationship between three tables

Subject: Relationship between three tables
From: Thomas Worrall <email@hidden>
Date: Tue, 30 Sep 2008 18:25:07 +0100

Forgive me if I'm missing something obvious: I'm fairly new to all this.

I have three tables: Performance, Seat, Booking. Each booking has one seat, and one performance. So, I could add a couple of one-to-many relationships from Booking to the other two.

But, each seat+performance combination can only have one booking maximum (zero is allowed).

It seems to me that EO should be able to do something magical here to enforce that. In other languages I would just use code before allowing an insert to check that such a booking didn't already exist, but I have been conditioned by WO to expect it to perform miracles for me.

Anyone any ideas?

Tom
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


Follow-Ups:

Re: Relationship between three tables
From: David Avendasora <email@hidden>


Prev by Date:
Re: Distinct Values in an NSArray

Next by Date:
Re: Relationship between three tables

Previous by thread:
Re: Distinct Values in an NSArray

Next by thread:
Re: Relationship between three tables

Index(es):

Date
Thread