3 Replies - 3737 Views - Last Post: 19 April 2012 - 07:26 AM

#1 DanDeCoder  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 30
  • Joined: 18-October 10

Very simple.. but highly frustrating to find (Crows Foot Notation)

Posted 18 April 2012 - 02:51 AM

All,

Wondering if someone could help here as I have reached the end of my tether with MS Access!
I've built a database using SQL and am currently in relationship view whereby I can see all the tables.

I'm trying to build relationships between the tables but the notations are incorrect - I need them to be in Crow's Foot style. I cannot for the life of me work out how to do this! I have done it previously but can't remember how I did it.

I appreciate this isn't a regular question but Google doesnt help!

Dan

Is This A Good Question/Topic? 0
  • +

Replies To: Very simple.. but highly frustrating to find (Crows Foot Notation)

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 9073
  • View blog
  • Posts: 34,115
  • Joined: 12-June 08

Re: Very simple.. but highly frustrating to find (Crows Foot Notation)

Posted 18 April 2012 - 06:49 AM

Isn't "crow's foot notation" something you would use on the entity-relationship diagrams? You know something you mock up in Visio or on paper, but not something that is visually shown in Access?
Was This Post Helpful? 0
  • +
  • -

#3 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: Very simple.. but highly frustrating to find (Crows Foot Notation)

Posted 19 April 2012 - 02:02 AM

Right, cannot change the notation style used by the Relationships builder.

What you might be wanting to do is change the jointype. Double click on the line linking the pk/fk fields to open dialog.

This post has been edited by June7: 19 April 2012 - 02:05 AM

Was This Post Helpful? 1
  • +
  • -

#4 DanDeCoder  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 30
  • Joined: 18-October 10

Re: Very simple.. but highly frustrating to find (Crows Foot Notation)

Posted 19 April 2012 - 07:26 AM

Brilliant! Thanks guys. I know it was something simple but I didn't think to actually double click on the join, I was convinced it was in another area.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1