seems to me that you should add a color auto-number to the color table as the primary key and a perm auto-number to the perm table and then link the primary key - customer number - to your desired elements in the color & perm tables.
It should look like this instead: Name Table: Customer number - primary key Last name - want to link this to the color date in the color table and the perm date in the perm table First name Street City State Zip Home phone 1 Home phone 2 Cell phone 1 Cell phone 2 Color Table: COLOR_NUMBER autonumber new primary key Color Date - you may link this to the "customer number" in the name table Color Formula Color Time Color Price Color Natural Level Color Comments Perm Table: PERM_NUMBER autonumber new primary key Perm Date - you may link this to the "customer number" in the name table Perm Solution Perm Long/Short Perm Texture Perm Dyed Perm Natural Perm Gray Perm Process Time Perm Rods Perm Price Perm Comments Mark - I may be wrong but I'm bitin at the bit cuz I think I know this one. --- Marcella <[EMAIL PROTECTED]> wrote: > Here is the Info: > > > > I am setting up a database for my hair stylist. I > have 3 tables set up - 1 > table is the basic address table (last name, first > name etc). I set up the > primary key as the customer number. The second table > is a table about the > Perm info - (perm date - formula - price etc). The > third table is the color > table (color date etc). The basic idea is that I > want to put in the customer > 1 time (relationship = one) (customer 12345 Joan > Smith) and the dates will > be the many relationship. Therefore Joan Smith can > have many dates for her > perm AND many dates for her color. There may be > several Joan Smiths, but the > unique identifier is the customer number. I am sure > this is possible, and > very easy, but unfortunately I do not know Access > enough to do this simple > thing. > > > > Name table - I have linked last name with color date > - the relationship I > want is last name (one) to color date (many) and > last name (one) to perm > date. I know this is a simple think, but I cannot > get the correct linking. > When creating the relationships - I am in the edit > relationship screen I do > get the one to many - however the one is the color > (perm) table and the many > is the name table. I have tried dragging from name > to color and from color > to name - and I get the same thing. I need the name > table to be the one and > the color (perm) table be the many. > > > > Name Table > > Customer number - primary key > > Last name - want to link this to the color date in > the color table and the > perm date in the perm table > > First name > > Street > > City > > State > > Zip > > Home phone 1 > > Home phone 2 > > Cell phone 1 > > Cell phone 2 > > > > > > Color Table > > Color Date - primary key - want to link this to last > name in the name table > > Color Formula > > Color Time > > Color Price > > Color Natural Level > > Color Comments > > > > Perm Table > > Perm Date - primary key - want to link this to last > name in the name table > > Perm Solution > > Perm Long/Short > > Perm Texture > > Perm Dyed > > Perm Natural > > Perm Gray > > Perm Process Time > > Perm Rods > > Perm Price > > Perm Comments > > > > > > _____ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf > Of Brett Collings > Sent: Thursday, August 10, 2006 3:36 PM > To: [email protected] > Subject: Re: [ms_access] One to many relationship > > > > Marcell, > > Questions > - Are the data types and names of the relational > keys identical? > - Have you tried right-click on the join line to > edit the relationship? > - How do you kon it's a one-to-one and not 1-many? > - Can you give us an idea of what the tables and > their fields are? > > Brett > > marcellagustantino wrote: > > > I am a new user to Access. I KNOW database design. > I have followed the > > steps to create a relationship but I am STILL > having problems. I must > > be missing something VERY basic. All I need to do > is to create a one > > to many relationship. When I pull up the edit > relationship box - there > > is NO way to change the relationship type - the > only choice is one to > > one - no way to change this. I have my primary > keys set up in each > > table. PLEASE help!!!!!!!!!!!!! > > > > > > -- > Brett Collings > Strengthening Families Administrator > D2D 46422 > DDI (04) 916 3422 > > ------------------------------- > This email message and any attachment(s) is intended > only for the > person(s) or entity(entities) to whom it is > addressed. The > information it contains may be classified as IN > CONFIDENCE and may be > legally privileged. If you are not the intended > recipient any use, > disclosure or copying of the message or > attachment(s) is strictly > prohibited. If you have received this message in > error please > notify us immediately and destroy it and any > attachment(s). > Thank you. The Ministry of Social Development > accepts no > responsibility for changes made to this message or > to any > attachment(s) after transmission from the Ministry. > ------------------------------- > > [Non-text portions of this message have been > removed] > > > > > > [Non-text portions of this message have been > removed] > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
