Prev: Snel geld verdienen
Next: have casting calls for female models in buffalo ny
From: Gina Whipp on 22 May 2010 01:28
Oops, junction table...

***Modified
Guardian - ID
relationship
isprimary

***Junction table
GuardianID
PeopleID

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

".:RoKsTaR:." <RoKsTaR(a)discussions.microsoft.com> wrote in message
news:2F00328C-CEE9-4F59-AD37-CFB7C82CA256(a)microsoft.com...
How does that relate 2 people though?

"Gina Whipp" wrote:

> That table is set up like an Excel spreadsheet, so in your case that would
> not work... Your table should be set up like this...
>
> Guardian - ID
> Peopleid
> relationship
> isprimary
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> ".:RoKsTaR:." <RoKsTaR(a)discussions.microsoft.com> wrote in message
> news:959D040E-B8BE-4AEA-BC48-A78505F5A1D4(a)microsoft.com...
> Thanks Allen :)
>
> So how would I work in my case? I need to establish a relationship
> between
> two or more people in my people table.
>
> My people table is simple:
>
> People - ID, Firstname, Lastname
>
> I'm relating the 2 or more in this table:
>
> Guardian - ID, Peopleid, peopleid, relationship, isprimary
>
> Cheers!
>
From: Allen Browne on 22 May 2010 09:03
Take a look at this article:
People in households and companies - modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

Everyone (children, guardians, etc) goes into tblClient.
For each grouping, you then create a record in tblGroup.
Then tblGroupClient has a record for each person in the group.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


".:RoKsTaR:." <RoKsTaR(a)discussions.microsoft.com> wrote in message
news:959D040E-B8BE-4AEA-BC48-A78505F5A1D4(a)microsoft.com...
> Thanks Allen :)
>
> So how would I work in my case? I need to establish a relationship
> between
> two or more people in my people table.
>
> My people table is simple:
>
> People - ID, Firstname, Lastname
>
> I'm relating the 2 or more in this table:
>
> Guardian - ID, Peopleid, peopleid, relationship, isprimary
>
> Cheers!

From: .:RoKsTaR:. on 24 May 2010 10:59
Thanks, I'll check that out :)
From: .:RoKsTaR:. on 24 May 2010 20:29

Ok, I sort of understand that, but am still a bit hazy. Could you explain
why this won't work? right now I have a student table to take the peopleid
and associate it with a studentid. Then I have a gaurdian table to associate
a persion as a gaurdian and then show the relationship to a particular
student.

address - addressid, address, city, province, postalcode
attendance – attendanceid, peopleid, lessondate, lessonstatus, lessonnotes
phone- phoneid, phonenum, extension, phlocation
email - emailid email, emailLocation, isprimary
webservice – webserviceid, username, service
people – peopleid, firstname, lastname
products – productid, producttype, productdesc, price

student – id, peopleid, lessonday, gender, DOB, iscurrent
guardian – id, peopleid1, peopleid2, relationship, isprimary

people_address – id, peopleid, addressid
people_phone – id, peopleid, phoneid
people_email – id, peopleid, emailed
people_webservice – id, peopleid, webserviceid

The deeper I get in this, the more I get confused ;)



From: Allen Browne on 24 May 2010 22:24
So you have a Student table and a Guardian table.
One student can have multiple guardians?
One guardian can have multiple students.

The simplest solution would therefore be to create a GuardianStudent table
with fields:
- GuardianID relates to Guardian.GuardianID
- StudentID relates to Student.StudentID

If a guardian has 3 students, they have 3 records in this table.
If a student has 2 guardians, they have 2 records in this table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


".:RoKsTaR:." <RoKsTaR(a)discussions.microsoft.com> wrote in message
news:1A8EE1CC-1C48-46BD-8943-046519AAC72E(a)microsoft.com...
>
> Ok, I sort of understand that, but am still a bit hazy. Could you explain
> why this won't work? right now I have a student table to take the
> peopleid
> and associate it with a studentid. Then I have a gaurdian table to
> associate
> a persion as a gaurdian and then show the relationship to a particular
> student.
>
> address - addressid, address, city, province, postalcode
> attendance – attendanceid, peopleid, lessondate, lessonstatus, lessonnotes
> phone- phoneid, phonenum, extension, phlocation
> email - emailid email, emailLocation, isprimary
> webservice – webserviceid, username, service
> people – peopleid, firstname, lastname
> products – productid, producttype, productdesc, price
>
> student – id, peopleid, lessonday, gender, DOB, iscurrent
> guardian – id, peopleid1, peopleid2, relationship, isprimary
>
> people_address – id, peopleid, addressid
> people_phone – id, peopleid, phoneid
> people_email – id, peopleid, emailed
> people_webservice – id, peopleid, webserviceid
>
> The deeper I get in this, the more I get confused ;)
>
>
>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Snel geld verdienen
Next: have casting calls for female models in buffalo ny