Prev: Option Group, Unbound Form: 2467 Object closed or doesn't exist?
Next: Access 2002 question
From: John W. Vinson on 12 Apr 2010 16:33
On Mon, 12 Apr 2010 12:40:01 -0700, Melissa Brown <Melissa
Brown(a)discussions.microsoft.com> wrote:

>Maybe I have been reading too long, but which should be the 'one' table? My
>example: cuptomers making annula reservations. Is the customer the one table?
> should the 'many' be the reservations? or vice versa? The reservations
>change, the customer stays the same. If I am making a form for reservations,
>does that make the customer the parent on the form or is the reservation form
>the parent and then the customer the child?

Each customer may have zero, one, two or many reservations.
Each reservation pertains to one and only one customer.

Customers are the "one" side, reservations the "many" - because one Customer
may have many Reservations, but one Reservation applies to only one customer.
--

John W. Vinson [MVP]
First  |  Prev  | 
Pages: 1 2
Prev: Option Group, Unbound Form: 2467 Object closed or doesn't exist?
Next: Access 2002 question