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] 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/
