I can't quite seem to figure out how to get a view page to show up for my scenario:
I have a database for a basketball league. One table has the schedule, another table has the results.
I have specified table link properties as:
- Master: Schedule -> Details: Results
- Link fields: gameid : gameid
- Display child record on: View Page
Yet, when my Schedule List page gets delivered, the Details link always is linked to the Results_list page, as such:
Results_list.php?mastertable=Schedule&masterkey1=4964
What I really want is the Results view page. (I can get to it by going to Results_list.php page and then selecting the View link):
- Basketball_Game_Details_view.php?editid1=3276&editid2=4964
Thus, I would like the link provided by the Master-Detail relationship to take the user to the details view page.
How can I achieve this?