Marcell,
Questions
- Are the data types and names of the relational keys identical?
- Have you tried right-click on the join line to edit the relationship?
- How do you kon it's a one-to-one and not 1-many?
- Can you give us an idea of what the tables and their fields are?
Brett
marcellagustantino wrote:
> I am a new user to Access. I KNOW database design. I have followed the
> steps to create a relationship but I am STILL having problems. I must
> be missing something VERY basic. All I need to do is to create a one
> to many relationship. When I pull up the edit relationship box - there
> is NO way to change the relationship type - the only choice is one to
> one - no way to change this. I have my primary keys set up in each
> table. PLEASE help!!!!!!!!!!!!!
>
>
--
Brett Collings
Strengthening Families Administrator
D2D 46422
DDI (04) 916 3422
-------------------------------
This email message and any attachment(s) is intended only for the
person(s) or entity(entities) to whom it is addressed. The
information it contains may be classified as IN CONFIDENCE and may be
legally privileged. If you are not the intended recipient any use,
disclosure or copying of the message or attachment(s) is strictly
prohibited. If you have received this message in error please
notify us immediately and destroy it and any attachment(s).
Thank you. The Ministry of Social Development accepts no
responsibility for changes made to this message or to any
attachment(s) after transmission from the Ministry.
-------------------------------
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
