rebecca Posted January 27, 2002 Share Posted January 27, 2002 Hi, everyone. I'm designing a student database for a customer that wants a social security number to be the unique field that identifies such record (a.k.a primer key) However, in the define field menu there isn't and option for this type of selection. Do you know a way to do this ? Let me be more clear by an example Let's say we have the following record: John Doe with social 609-45-5862. This person has taken Chemestry 101, Law 302 in the first semester. Now the second semester comes up and I need to enter more classes for John Doe, but I only want to type his social security number so that his name and personal information can show up. How do I accomplish this? I hope I was clear. Thank you guys Bye Becca Quote Link to comment Share on other sites More sharing options...
Robert Schaub Posted January 27, 2002 Share Posted January 27, 2002 This needs to be done with a relationship and a portal. I assume you have 2 DB's Student ID Student Coarses Relationship to be Student ID(SSN) :: Student Coarses(SSN) When you enter the SSN into the Student ID SSN field you will see all the Info for the Student in the portal. Quote Link to comment Share on other sites More sharing options...
rebecca Posted January 28, 2002 Author Share Posted January 28, 2002 Thank you chopper. I'll try that and get back to you. Becca Quote Link to comment Share on other sites More sharing options...
rebecca Posted January 29, 2002 Author Share Posted January 29, 2002 Hi chopper. I did the relationship command just as you told me and it worked. Now everytime I enter the social security in the ss field the name and the last name shows up, which is what I wanted. Thank you a bunch and a little kiss as well. I have another question though. I created a report like this: Social Classes Semester 609-91-55 Math Fall 1999 The problem I'm having is that the report is creating separated records with the exact social security. For example: Social Classes Semester 609-91-55 Math Fall 1999 ------------------ Social Classes Semester 609-91-55 PE Fall 1999 ------------------ Social Classes Semester 609-91-55 Music Summ 2000 ------------------ My question is: what do I do to have the report to be like this? Social Classes Semester 609-91-55 Math Fall 1999 PE Spring 2000 Music Summ 2000 thank you once again, Becca Quote Link to comment Share on other sites More sharing options...
Robert Schaub Posted January 29, 2002 Share Posted January 29, 2002 You need to create a subsummary layout sorted by 1 Social 2 Semester 3 class Will look like this 000-00-0000 Jane Doe class 1 fall 2001 class 2 winter 2001 class 1 spring 2000 000-00-0001 John Doe class 1 Winter 2001 class 1 spring 2002 class 2 spring 2002 a litte clue your semester should be a number i.e. spring = 1 .... .... Winter = 4 sort in assending order. Quote Link to comment Share on other sites More sharing options...
rebecca Posted January 30, 2002 Author Share Posted January 30, 2002 Ok sweetie, thank you a bunch I made it work thanks to you. Now my last question of the day. This question is similar to the report question but this has to do with the "Find" mode. When I go to find a record. It finds the records of such person, but it displays the found records separately. Like this Page 1 John Doe Social 609-91-55 Classes Math Semester Fall 1999 ------------------ Page 2 John Doe Social 609-91-55 Classes PE Semester Summer 1999 ------------------ and so on. When I perform a find for a certain person. Is there any way to have all records display tin only one page. Kind of like this: 000-00-0001 John Doe class 1 Winter 2001 class 1 spring 2002 class 2 spring 2002 Do I have to create like a script kinda or ? Thank you a million times. Becca Quote Link to comment Share on other sites More sharing options...
rebecca Posted January 30, 2002 Author Share Posted January 30, 2002 I forgot to ask you chopper. Do you really do contract stuff? Because I might have another and more complicated database for you to do. Just E-mail me. Quote Link to comment Share on other sites More sharing options...
Robert Schaub Posted January 30, 2002 Share Posted January 30, 2002 Rebecca Create a calculation field called Student_coarses = calc = Class & " " & Semester & " " & Year Now create a field called Student_Find = Global = Text Script = Enter Browse Mode [ ] Set Error caption [On] Enter Find Mode [ ] Pause Script [ ] Perform Find [ ] If Status(CurrentError)= 401 Show Message [No records found] [ ] Go to layout [Original] Show All Else Set Filed [student_Find, '' "] Set Field [student_Find] (Student name & '" "& "SSN#& SocialSecurity Number Go to Record Request [First]) loop Set Field (Student_Find, Student_Find & "¶" & Student_coarses ) Go To Record Request [Next] [Exit after last] End Loop End If Now your [student_Find] field should look like this Student Name SSN# 000-00-0000 Class1 Winter 2001 Class2 Winter 2001 Class1 Spring 2002 As Far as contracting work goes it is yes. I do it part time now, But hope to be doing it full time soon. I am also working on my website where I am also working on my website where I will post demo versions of my stuuff for download. chopper Quote Link to comment Share on other sites More sharing options...
Robert Schaub Posted January 30, 2002 Share Posted January 30, 2002 Another and easier way to do it is create a list view layout Put the student name and social security number in the header and the rest of the information in the body. * * Quote Link to comment Share on other sites More sharing options...
Robert Schaub Posted January 30, 2002 Share Posted January 30, 2002 Rebecca How did you make with with your lastest quest? Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.