[DanDeCoder]

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

[modi123_1]

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?

[June7]

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

[DanDeCoder]

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.