| Computers Forum Index » Computer - Databases - MS Access » Relationship problem... |
|
Page 1 of 1 |
|
| Author |
Message |
| Mistirios... |
 Posted: Wed Oct 21, 2009 4:52 pm |
|
|
|
Guest
|
In my database i have a relational system divided in physical persons
and companies. Persons can either be customers, business contacts or
employees. I have related each person through a subform in the form of
persons to a company by one one or more of the above categories.
Employees are logically a part of the stored persons.
I run a query that successfully returns the persons that are employees
(by giving me each person's id) but i don't how to relate this in my
Employees Table.
I've tried various forms of relationships but i haven't had any
result. To my understanding this is a one-to-one relationship but i
haven't be able to make it work. The goal is after the query to open a
form of employees to add only employee related data and not personal
data that are being managed only by the persons form.
The same concept i want to implement in Companies as they also can by
Customers, Suppliers or something else.
Any ideas?
Thanks in advance! |
|
|
| Back to top |
|
|
|
| paii, Ron... |
| Posted: Wed Oct 21, 2009 9:46 pm |
|
|
|
Guest
|
"Mistirios" <g.stravopodis at (no spam) gmail.com> wrote in message
news:568e243f-05c1-4a3e-a7cb-dcd15c691396 at (no spam) p9g2000vbl.googlegroups.com...
Quote: In my database i have a relational system divided in physical persons
and companies. Persons can either be customers, business contacts or
employees. I have related each person through a subform in the form of
persons to a company by one one or more of the above categories.
Employees are logically a part of the stored persons.
I run a query that successfully returns the persons that are employees
(by giving me each person's id) but i don't how to relate this in my
Employees Table.
I've tried various forms of relationships but i haven't had any
result. To my understanding this is a one-to-one relationship but i
haven't be able to make it work. The goal is after the query to open a
form of employees to add only employee related data and not personal
data that are being managed only by the persons form.
The same concept i want to implement in Companies as they also can by
Customers, Suppliers or something else.
Any ideas?
Thanks in advance!
Looks like you need to add PersonID to the Employee table. If the Employee
table does not have a primary key, you could use PersonID as the primary. |
|
|
| Back to top |
|
|
|
| Element... |
| Posted: Fri Oct 23, 2009 5:54 pm |
|
|
|
Guest
|
The title to this post reminded me...I have reationship problems too
-- regardless of attractiveness, every woman that I date turns out to
be a complete nut bar!
Oh wait...we're taking about databases... |
|
|
| Back to top |
|
|
|
| Mistirios... |
| Posted: Fri Nov 06, 2009 11:23 am |
|
|
|
Guest
|
On Oct 23, 8:54 pm, Element <b2flying.fortr... at (no spam) gmail.com> wrote:
Quote: The title to this post reminded me...I have reationship problems too
-- regardless of attractiveness, every woman that I date turns out to
be a complete nut bar!
Oh wait...we're taking about databases...
I guess u have a lot of time and don't know what 2 do with it, eh? |
|
|
| Back to top |
|
|
|
|
