Here is a look at my chart, I know it is a little bit of a mess, I started to just have a field in the player record, but if I get multiple pieces of information I just want the lates to see and have the others to look at.
Give your "notes" table an auto-entered serial number field if it does not already have one. Use Replace field contents to give your existing notes records a serial number.
Now you have two options:
1) Add a sort order to the relationship between the two tables that sorts your records by this new serial number field in descending order. This makes the most recently added related record the "first related record" on your layout.
2) Put the fields from notes inside a portal, specify the same sort order, but from within portal setup instead of at the relationship level.
Yeah I already had a serial number to designate the notes. I tried sorting the relationship on the notes side to this serial number in descending order and it still just showed the earliest entry
I dont have to add a sort field on the other side as well right?
No, that's all you need and it should work. Make sure that pk_note id is of type number. If you added it after you already had some notes, the existing records won't have an ID untilyou give them one. Make sure that the fields are added from "Free Agent Notes"--not some other occurrence of the same table and and in like manner make sure that your layout is based on Player Base.
Those are the obvious issues to check for this.
You are the man!! I thought I did that, but as usual you prove me to me an idiot. Thank You this is a great little tool
I have a question on addition that I want to make to my database.
There are events this summer called NBA Summer Leagues. THere are two Leagues one in Las Vegas and one in Orlando. I want to scout these players and put their reports into the database. I started a Summer League table where I have a record for each summer league and joined them by the player ID. My issue is that some player play in multiple leagues so this is an issue for me. NOw I remember having an event participation table where I can put reports and ratings for the players that particiapte in these. I like this as I can put a player in multiple events.
The plus for doing it this way is that I can assign players to teams and create portlas to have rosters for each team and then set the name fields to buttons that can open a new window and I can enter the scouting reports. Problem is I cant have a player play in two events then.
Problem is I cant have a player play in two events
Events is just a table linked via join to the team table as I recall. You can add as many event records as you need and I don't see any barriers to listing the same player for more than one event. This wouldn't happen in real life, but as far as the database is concerned, the same player could be on the roster of both teams in the same event and it still works.
Right so in the event participation I know that it can have the players play in both events. In the event participation is there a way to have rosters of the teams on the layout? I like the event participation because I can give a player a rating and rank them. I like having rosters in front of me so I can set the names to buttons that takes me to the rating layout.
So long sotry short, I'd like to track the players in summer league and have rosters for players in each event. Possible??
It's possible, but before we dive into the details, can you refresh my memory as to the tables you have?
I'm picturing these relationships, but may not be accurately reproducing the tables involved:
Believe it or not I figured it out. It's not the best way , but just used the event participation layout. I put 3 portals up listing the players who participated and sorted 1 by name, 1 by team, and i by jersey number and team. I set buttons up to click on the player's name to open a new window and write the scouting report. I have another participation layout that I have to click on a players name to put them in the summer league so they are listed. Now once all the players are added before the event I can just go to the event lauout and the players are already there.
Isn't to bad and does everything I need it to do.
I think I figured it out. I have the same event participation.
First I made a lyout listing all the players in my database so I can click on their name which is a button that opens up a window that I can put them in a summer league.
In the event layout I put a portal listing all the players that are in the event which I'll set up before the event starts. In the portal the name of the player is also a button that I can put a new scouting report in a new layout. I figure this makes sense and allows me to get some things done.
How do I add a search feature to my protal? I've sen it done, but looks tricky. ANy advice??
Hope your fourth was goood.
4th was great for me, but not so great for a family member that's an HS Band Teacher, he runs a stand for selling FW's and theives broke in and stole all their remaining product--wiping out thousands of dollars in fundraising...
I think you are describing a feature where the portal is filtered and the user can enter/select data in one or more fields that are referenced in the filter expression. Take a look at this demo file and see if any of the portals across the bottom are similar to what you'd like to see: