Jump to content

Randy Bricker

  • Posts

  • Joined

  • Last visited

Randy Bricker's Achievements


Newbie (1/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges



  1. OK. I did as you suggested. I now have two tables, one for players that has a portal to the other table transactions. I have a field in players called "Team". I want to write a calc that finds the last "transaction" for the player and places the new team name in the "Team" field. All of the transactions have a date associated with them. While I am able to find the latest date (using the Max function) I have not figured out how to place the correct team in the "Team" field. Thank you ahead of time for your help.
  2. Thanks for the response. I will give that some thought. It would be a lot of reconfiguring, but you might be right. Right now in the Players table I have one layout for individual players (form view) and one for teams (list view).
  3. I have created a related database for my Strat-o-matic baseball league. I want to track a player's movement over his entire career as he moves from team to team by way of the player being originally drafted into the league, traded, cut, drafted again, etc. I have created one table that is the master Player Tracker, which has portals to the following tables: Rookie Draft, Trades, April Supplemental Draft, Mid-season Supplemental Draft, Players Cut. All of these tables have a "date" field that records the occurrence, and a "team" field that records the team. There are multiple times a player changes teams. I'm trying to write a formula for the Master Player table that will search these related databases and tell me what team the player is currently on (the occurrence that happened most recently) and then enter the current team in the Master Player table "team" field. Any help would be appreciated. Thanks.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.