A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

bad relationship?



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2010, 06:45 PM posted to microsoft.public.access.gettingstarted
shumate62
external usenet poster
 
Posts: 13
Default bad relationship?

Ok- so I have created a table for my contacts called Person (with address,
phone, etc) and table for Group (with speaker, author, attendee) and then a
table for PersonGroup and created a one-to-many between the two.
Then I tried to create a Lookup wizard for GroupID from the Person table in
order to be able to select the groups that the person are a part of.
But yet when I go to forms- nothing. Everything seems to save ok in tables
and then I create the form and there's nothing in my drop down.
Is this the wrong way to create the tables?
I want to be able to fill out my Person forms with contact information and
then be able to select several group types in their contact form. Is the
lookup going to allow for multiple selections of groups anyway?
Ads
  #2  
Old April 18th, 2010, 07:08 PM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default bad relationship?

There should not be a GroupID in the Person table. The PersonGroup table
should consist of minimally a PersonID and GroupID combination. You create a
subform based on the PersonGroup table and place it on your main Person
form. The only control needed in the subform is a combo box with a control
source like:
SELECT GroupID, GroupTitle
FROM Groups
ORDER BY GroupTitle;
Since you didn’t provide actual field names, you may need to change this.

Set the Link Master/Child properties to the PersonID field.


--
Duane Hookom
MS Access MVP


"shumate62" wrote in message
...
Ok- so I have created a table for my contacts called Person (with address,
phone, etc) and table for Group (with speaker, author, attendee) and then
a
table for PersonGroup and created a one-to-many between the two.
Then I tried to create a Lookup wizard for GroupID from the Person table
in
order to be able to select the groups that the person are a part of.
But yet when I go to forms- nothing. Everything seems to save ok in tables
and then I create the form and there's nothing in my drop down.
Is this the wrong way to create the tables?
I want to be able to fill out my Person forms with contact information and
then be able to select several group types in their contact form. Is the
lookup going to allow for multiple selections of groups anyway?


  #3  
Old April 18th, 2010, 07:38 PM posted to microsoft.public.access.gettingstarted
shumate62
external usenet poster
 
Posts: 13
Default bad relationship?

OK
1. I took away the groupID from Person table
2. I created the subform through wizard and got just another blank box
without the dropdown bos to choose from. to create the subform I just
followed the help instructions which are pretty straightforward so I dont'
know where that lead me wrong...



"Duane Hookom" wrote:

There should not be a GroupID in the Person table. The PersonGroup table
should consist of minimally a PersonID and GroupID combination. You create a
subform based on the PersonGroup table and place it on your main Person
form. The only control needed in the subform is a combo box with a control
source like:
SELECT GroupID, GroupTitle
FROM Groups
ORDER BY GroupTitle;
Since you didn’t provide actual field names, you may need to change this.

Set the Link Master/Child properties to the PersonID field.


--
Duane Hookom
MS Access MVP


"shumate62" wrote in message
...
Ok- so I have created a table for my contacts called Person (with address,
phone, etc) and table for Group (with speaker, author, attendee) and then
a
table for PersonGroup and created a one-to-many between the two.
Then I tried to create a Lookup wizard for GroupID from the Person table
in
order to be able to select the groups that the person are a part of.
But yet when I go to forms- nothing. Everything seems to save ok in tables
and then I create the form and there's nothing in my drop down.
Is this the wrong way to create the tables?
I want to be able to fill out my Person forms with contact information and
then be able to select several group types in their contact form. Is the
lookup going to allow for multiple selections of groups anyway?


  #4  
Old April 18th, 2010, 09:04 PM posted to microsoft.public.access.gettingstarted
Gina Whipp
external usenet poster
 
Posts: 3,500
Default bad relationship?

shumate62,

Just to be clear are you trying to select a Group per person? If yes... and
before you go into anymore detail...

1. Does each person only belong to one group?
2. Did you use the wizard to create a look-up field in the table?

--
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

"shumate62" wrote in message
...
OK
1. I took away the groupID from Person table
2. I created the subform through wizard and got just another blank box
without the dropdown bos to choose from. to create the subform I just
followed the help instructions which are pretty straightforward so I dont'
know where that lead me wrong...



"Duane Hookom" wrote:

There should not be a GroupID in the Person table. The PersonGroup table
should consist of minimally a PersonID and GroupID combination. You create
a
subform based on the PersonGroup table and place it on your main Person
form. The only control needed in the subform is a combo box with a control
source like:
SELECT GroupID, GroupTitle
FROM Groups
ORDER BY GroupTitle;
Since you didn’t provide actual field names, you may need to change this.

Set the Link Master/Child properties to the PersonID field.


--
Duane Hookom
MS Access MVP


"shumate62" wrote in message
...
Ok- so I have created a table for my contacts called Person (with
address,
phone, etc) and table for Group (with speaker, author, attendee) and
then
a
table for PersonGroup and created a one-to-many between the two.
Then I tried to create a Lookup wizard for GroupID from the Person table
in
order to be able to select the groups that the person are a part of.
But yet when I go to forms- nothing. Everything seems to save ok in
tables
and then I create the form and there's nothing in my drop down.
Is this the wrong way to create the tables?
I want to be able to fill out my Person forms with contact information
and
then be able to select several group types in their contact form. Is the
lookup going to allow for multiple selections of groups anyway?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.