Hello dnn professionals,

I intend to replace my ms-access database by my dotnetnuke portal.
The database holds adresslists and projektdata in more than 50 related tables.
Now I'm looking for a dnn-modul to easily create forms and reports like it is possible with ms-access.

Is there any module out there to meet this demand ?

Thanks in advance for all recommendations.

matthias

Hello,

There are many form based modules out there, to give you an example here is a search on snowcovered for form modules which shows you some of the options available.

Can anyone provide any tips for what module they prefer?

Hello Lee,

I just watched your videos concerning UDTs.

Thanks a lot for this information. I can use user defined tables for most of the things I intend to do.
But there are still two questions left.

1. How can I deal with 1:n related tables. (for instance one customer with many orders...). Is there any way to link to a filtered table with the filter defined by the selected dataset I was linking from.
 1.a.) When I add new records to the n table, how can I achieve the foreign-key to the 1 table to be set correctly (I hope I made myself clear ;-))

2. How can I make an old table that allready exists to a UDT. I' don't want to create the table once more and insert the data again (because I have lots of tables with a lot of data in it. I know how to do UPDATE and INSERT queries but maybe there is an easier way to achieve my goal ?

thanks in advance
matthias

Hello,

After viewing the presentation at open force Europe, I don't think the UDT module can deal with 1:n related tables, is designed as a list rather than dealing with relations.

2) at the same presentation Stefan gave an example where he imported the data from an Excel file directly into the UDT module, this is a new feature in the UDTv5 and I'm not sure if it has even been released yet, so at the moment you may have to look at SQL queries, thanks,

Hello,

the answer to my question can be found in the german dotnetnuke community.
Sebastian Leupold  gave me the following link.
www.deutschnetnuke.de/tabid/140/Default.aspx
I didn't test it till now but the announcement sounds very promising.
I ' ll let you know when I know further details...

matthias

thanks for the info, yes the new name for UDT will be forms and lists module.