VB. Net Form Menu dynamically linked to SQL Table values

[ILCSP@NETZERO.NET]

Hello,

I am trying to create a form in Visual Basic.Net with a dynamically
created Menu bar. I need the drop down part of a menu item (Reports)
to be dynamically generated according to the values of a SQL 200
table.

for Example, let's say I have this SQL table with the following fields:

Orders ReportName
_____ ______________
89BB BBReport_Order
89BB BBReport_Invoic e
89BB BBReport_Custom er
32NN NNReport_Order
32NN NNReport_Invoic e
32NN NNReport_Custom er
...

Now, let's assume my form is finished and working. The current user is
a 'NN' person. Therefore, I need to display the NN reports in my form
Menu toolbar. I need the Reports Menu Item to be '32NN' and underneath
show the name of the reports as submenus. The same would be for an
user that's a 'BB' but showing the 89BB field as the menu item and the
BB reports as submenus instead.


Here's a visual representation of my menu bar. (user's a NN)

File Reports Help
Exit 89NN About
NNReport_Order
NNReport_Invoic e
NNReport_Custom er


Does anyone know how to accomplish this? Is there an example similar
to this that I could use? What the user will do is to click a report
name and then either preview it in a Crystal report Viewer or send it
directly to the printer.

Thanks as always for all your help.