I'm new here (first post).
I have already read the great articles on this page but never posted until now.
I am looking for some guidance on this and hope you experts can help me.
Overview: I want to create a Request form, so employees can request tickets to the Home Games of our local Baseball team. We know we already get 20 tickets to each game. So, Here is my thought process, you can tell me if im on the right track or i need to change it up.
List 1 = Create a "Games" list that shows the "Opponent" "time/date of the Game" "How Many Tickets we Start out with" "How Many Tickets are left"
List 2 (The Request List) The Employee can put down their name, and use the Dropdown to select the Game they want to go to. When they select the game, there will be a calculated Field that show how many tickets are left(This can pull from List1 Above"
That seems simple, but I'm stumped.
Also, How can you display a Calculated column(How many tickets are left), on a SharePoint Page (like if i wanted to keep the numbers updated on the home page. All it should do is pull from that List1 column right?
Please go easy on me as its my first post...hehe