ISlp59lp Posted December 10, 2013 Report Share Posted December 10, 2013 I'm working on a basketball games database. I have a table that lists schoools: TBL_SCHOOL { schoolid, schoolname } I have another table that lists games: TBL_GAMES { gameid, gamedate, visitorschoolid, homeschoolid } How do I set up a view and/or datapage that will show: gamedate - visitor schoolname - homeschoolname ??? Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted July 5, 2017 Report Share Posted July 5, 2017 Create a relationship and in your relation ship choose to see the name instead of ID, this will resolve the issue. Refer to http://howto.caspio.com/tables-and-views/relationships/relationship-settings/ cbaker10 and Master 2 Quote Link to comment Share on other sites More sharing options...
Question
ISlp59lp
I'm working on a basketball games database.
I have a table that lists schoools:
TBL_SCHOOL {
schoolid,
schoolname
}
I have another table that lists games:
TBL_GAMES {
gameid,
gamedate,
visitorschoolid,
homeschoolid
}
How do I set up a view and/or datapage that will show:
gamedate - visitor schoolname - homeschoolname
???
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.