Class:
Thanks so much I am still having problems. 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 Clauss Gilbert Sent: Thursday, August 10, 2006 6:12 AM To: [email protected] Subject: [SPAM] RE: [ms_access] One to many relationship Access makes a 1 to 1 relationship when you try to link two primary keys with each other. With MS-Access remember you must link the fields, not the tables. So, first delete the relationship if you think it is wrong. You an delete it by right clicking on the link, in the relation window. Then make sure the relationship you draw is between a normal field (not a primary key) of a first table, and the primary key of the other table. Normally there is no problem. (if your primary keys are multi field, it might be a little more dfficult, let us know) GC -----Message d'origine----- De : [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com [mailto:[EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com] De la part de marcellagustantino Envoyé : lundi 7 août 2006 16:11 À : [EMAIL PROTECTED] <mailto:ms_access%40yahoogroups.com> ps.com Objet : [ms_access] One to many relationship 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!!!!!!!!!!!!! Yahoo! Groups Links [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/
