Register  |  Login   
HomeUniversal ListSupport ForumsPortfolioContact Us
  Forum  
SearchForum Home
  Universal List  Universal List Version 4.x  Master Details?...
 Master Details?
 
 8/17/2007 4:49:48 AM
ULSales
32 posts


Master Details?

I have read about MasterDetails in your UL forum but I still don't think I understand how to use it.

I am trying to develop a feature which will "pull fields" into a List based on other Reference fields in the same form. For example, let's say that I am a soccer fanatic. I want to build a database of soccer games which I have attended. I set up a table/form where I want to add a record of each soccer game I attend.

Let's say the form requests me to enter Date, Host Team, and Opponent. Then when I go to my grid page to view all the records, I would also like to display "Street Address", "City", and "Country" for each record in the table.

That information would be pulled automatically via reference from a different table where I have specified the Street Address, City, and Country for any Host Team in my drop down list which may be selected. Questions: 1) Is MasterDetails appropriate for this? Your examples in the forum were not clear to me.

Please explain the syntax a little more clearly. 2) If MasterDetails won't work for this, then can this be done with a different tag or feature instead?

Thanks! Mike S. (Not technically skilled)


Universal List Customer Service & Sales
 8/17/2007 4:51:24 AM
ULSales
32 posts


Re: Master Details?

Mike,

what you describe is not really a master table feature - it is done 'automatically' using multiple tables and the reference field.

here is your application with links to the country and team tables from a list of games:

http://www.cookdnn.com/UniversalList/Demo/DemoMasterDetails/tabid/84/Default.aspx

here's what I did:
1. Add UniversalList module to page

2. Create these tables and fields

ulDemoSoccer_Team
 teamName
 teamAddress
 teamCity
 teamCountry (lookup of country)

ulDemoSoccer_Country
 countryName

ulDemoSoccer_Game
 date
 host (lookup of team)
 visitor (lookup of team)
 notes

3. Add sample data in country and team tables by switching betweeen tables and exiting/ entering configuration

4. Add records to the games table; change the main template to have a border and only one column/ grid.

Please let me know if I missed something.

Adam


Universal List Customer Service & Sales
 8/21/2007 2:22:53 AM
host
257 posts
4th


Re: Master Details?

Mike

If you have any additional question, then i can help you since back to work. Please contact us on support@cookdnn.com

Thanks

  Universal List  Universal List Version 4.x  Master Details?...
Free DotNetNuke dnndir.com DotNetNuke.fr About Us DotNetFreaks Asp.net Directory - Applications, Controls, ASP.NET hosting, Tutorials www.alldnnskins.com DotNetNuke Powered! Snowcovered
 
CookDNN