Lineage Diagrams

[HansBades]

What options are available to turn database data into a visual diagram that demonstrates the flow? For instance, I have a database that tracks the locations and types of SKUS. A report can tell me what skus are located in what warehouse and then shows me what work order site they are sent to. Is there an easy way to create a visual of this? Thanks.

[June7]

MicroSoft Visio maybe.

[CJ_London]

there is quite a lot you can do using vba to move and resize controls so may be possible. But I get the feeling that is not what you mean. I suspect you mean an interactive report - click on a warehouse, display the sku's, then click on a sku to see where its gone.

Do you have an example of what you mean

[orange]

I agree with Ajax and suggest you mock up a report --just a picture/crude diagram of what you foresee as the"report" -- to provide readers with some context.