indesisiv
Access - What's that?
- Local time
- Today, 17:42
- Joined
- Jun 13, 2002
- Messages
- 265
Hi all,
I am currently trying to get a full list of GP's and practices in our local area together so that in a form you can use cascading combo boxes to select a GP name and from that select a surgery that the GP is at.
That bit is straight forward but after looking at it i am sure that there is a better way of doing this.
Currently i have a one to many table with GP's as the one and Practices as the many side. BUT after putting on surgery in there are five GP's in it so the surgery info is repeated 5 times in the Practices table.
I think that i will have to use some sort of many to many tables as each GP can be at more than one practice and each practice can have more than one GP.
How would i set up a relationship like this as i have never had to do it before and i am a little uncertain.
I have attached a picture of what my current relationship looks like.
Any help is greatly appreciated.
Steve
I am currently trying to get a full list of GP's and practices in our local area together so that in a form you can use cascading combo boxes to select a GP name and from that select a surgery that the GP is at.
That bit is straight forward but after looking at it i am sure that there is a better way of doing this.
Currently i have a one to many table with GP's as the one and Practices as the many side. BUT after putting on surgery in there are five GP's in it so the surgery info is repeated 5 times in the Practices table.
I think that i will have to use some sort of many to many tables as each GP can be at more than one practice and each practice can have more than one GP.
How would i set up a relationship like this as i have never had to do it before and i am a little uncertain.
I have attached a picture of what my current relationship looks like.
Any help is greatly appreciated.
Steve