I have a table consisting of people and their attributes. I would
like to create a relationship matrix table that records the
relationships between the people. So the two tables would look
something like this:
tblPeople
*ID, AutoNumber
LastName, Text
FirstName, Text
Height, Text
Weight, Text
etc...
tblRelationshipMatrix
*Person1, Lookup (tblPeople)
*Person2, Lookup (tblPeople)
Relationship, Memo
* - Primary Key
I can't figure out a way to make this table work correctly. I'd like
each combination of two people to be unique. Would anyone have
suggestions on how to do this cleanly?
Thanks,
MW 3 1596
Mason,
Can you give us a scenario that you are trying to manage with relationships?
Plug some data into the structure, and maybe that will help us and you help
yourself. Give us an example of the rows and columns actually representing
the data?
IE what does Person1 lookup. Person2.Lookup? Is the lookup the ID of
People table?
Data really tells the story!
Barry
"Mason" <ma***@codemonkey.cc> wrote in message
news:eb**************************@posting.google.c om... I have a table consisting of people and their attributes. I would like to create a relationship matrix table that records the relationships between the people. So the two tables would look something like this:
tblPeople
*ID, AutoNumber LastName, Text FirstName, Text Height, Text Weight, Text etc...
tblRelationshipMatrix
*Person1, Lookup (tblPeople) *Person2, Lookup (tblPeople) Relationship, Memo
* - Primary Key
I can't figure out a way to make this table work correctly. I'd like each combination of two people to be unique. Would anyone have suggestions on how to do this cleanly?
Thanks,
MW ma***@codemonkey.cc (Mason) wrote in message news:<eb**************************@posting.google. com>... I have a table consisting of people and their attributes. I would like to create a relationship matrix table that records the relationships between the people. So the two tables would look something like this:
tblPeople
*ID, AutoNumber LastName, Text FirstName, Text Height, Text Weight, Text etc...
tblRelationshipMatrix
*Person1, Lookup (tblPeople) *Person2, Lookup (tblPeople) Relationship, Memo
* - Primary Key
I can't figure out a way to make this table work correctly. I'd like each combination of two people to be unique. Would anyone have suggestions on how to do this cleanly?
Thanks,
MW
Join the tables in a query. Just add Person multiple times and alias it.
Sure, Barry. I'll give an example of what's contained in tblPeople.
ID: 1
LastName: Doe
FirstName: John
Height: 5'10"
Weight: 175
DOB: 7/7/77
ID: 2
LastName: Smith
FirstName: Lisa
Height: 5'3"
Weight: 150
DOB: 5/5/75
Now the relationship matrix:
Person1: 1
Person2: 2
Relationship: John thinks Lisa is pretty cool, although she's been
weird lately. Everyone in the office makes fun of her weight,
although John only goes along with it half-heartedly.
Person1: 2
Person2: 1
Relationship: Lisa has overheard John call her fat while he was
laughing it up with other coworkers. Already self-consious about her
weight, she strikes back by saying negative things about his work
habits to anyone in a position of influence.
What I don't want:
Person1: 1
Person2: 1
I also want to enforce referential integrity.
I hope that helps,
MW
"Barry Young" <yo******@insightbb.com> wrote in message news:<7JM1d.194271$mD.50318@attbi_s02>... Mason,
Can you give us a scenario that you are trying to manage with relationships?
Plug some data into the structure, and maybe that will help us and you help yourself. Give us an example of the rows and columns actually representing the data? IE what does Person1 lookup. Person2.Lookup? Is the lookup the ID of People table?
Data really tells the story!
Barry
"Mason" <ma***@codemonkey.cc> wrote in message news:eb**************************@posting.google.c om... I have a table consisting of people and their attributes. I would like to create a relationship matrix table that records the relationships between the people. So the two tables would look something like this:
tblPeople
*ID, AutoNumber LastName, Text FirstName, Text Height, Text Weight, Text etc...
tblRelationshipMatrix
*Person1, Lookup (tblPeople) *Person2, Lookup (tblPeople) Relationship, Memo
* - Primary Key
I can't figure out a way to make this table work correctly. I'd like each combination of two people to be unique. Would anyone have suggestions on how to do this cleanly?
Thanks,
MW This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Fred |
last post by:
Hi.
How do I import while mapping an excel table to an access table please???
I've searched around and all I can find is a software product or code that
does the same thing as the access...
|
by: Wes Dabney |
last post by:
My name is Wes and I have been working with Access for a few years now,
though I know I'm not an expert, this forum has helped me many times without
me needing to post a question. Alas, I have...
|
by: Leinad Kong |
last post by:
I'm using Access 2002, as front-end and back-end as well:
1) I faced database corrupted problems, when more than 1 user edit
concurrently.
I'm using All-records Locking, and open-exclusively as...
|
by: Terry |
last post by:
Hello,
I wonder if anyone can shed light on this problem for me. I have an
Access 97 front end with an SQL 2000 database. There is a Business main
form with an Owner subform and corresponding...
|
by: Steve |
last post by:
One of our clients recently upgraded their Office version to 2003. When
they tried to run our program (written in Access 2000), they ended up
with the wrong data. My coworker and I have tested this...
|
by: alexandre.brisebois |
last post by:
Hi, I am using access 2003, I would like to know if there is an option
to reorganize the tables in a maner that is readable, as we can do in
sql sever 2000 or 2005.
I have been given a database...
|
by: NickName |
last post by:
This question probably has been asked many a time. And yet I feel it
is still relevant for one thing a search on this NG does not produce a
desirable answer.
It is kind of disappointing that MS...
|
by: Hammy |
last post by:
Hi there,
Wonder if you can help me with my dilema ! ?
I currently have an access2000 database which works just fine, but when I come to open it with access2002 the relationship table is...
|
by: pokerboy801 |
last post by:
OK, I will try to explain this as clearly and as concise as possible.
I am using Access, which has three MS Excel Linked tables, to store
call center metrics for reps. My Excel workbook has three...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |