Linking Access Database to Visio

[annemrosenberg]

Hello There!

I am trying to make an office plan in Visio based on an Access database.

I have a one-to-many relationship in access which shows that each desk can have more than one employee (we have day/night shifts).

KI have imported the database but now how can I show TWO Records(employees) within ONE shape(desk) in Visio?

Thanks for any help anyone can give me!



Anne

[June7]

Seems more like a Visio question than Access.

Possible options:

1. two shapes sitting on top of each other

2. VBA code to read through records and concatenate the employees