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)
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
Mike
If you have any additional question, then i can help you since back to work. Please contact us on support@cookdnn.com
Thanks