Hello,

I have 2 portals side by side...sort of similar to the school/student
problem but with a little twist. So he best analogy I can use to
describe my problem, although still not a perfect one, would be a pro
sports drafting system (for all you sports fans)

The portal on the left contains every player available in the draft,
with a drop down field above it letting you select from which college
you want to see every available player (so it's not EVERY single
player available for the draft, it's every player broken down by
college.) So if you select, say, University of Texas, every eligible
UT player is shown in the portal, and if you select University of
Florida, every player from that school and so on....

The right-side portal has a draft order...1,2,3, etc with the player's
name and their school.

The problem I am having (well it's more a want than a need) is that I
would like the names to disappear from the left portal when it is on
the right portal. I need the players to stay on their table (for
future drafts let's say...so I can't 'cut' the names over, just
'copy') I'm thinking there is a way to only show unselected players
only in a certain draft on the left side without having to copy the
entire Player table over (a waste of space) for each draft.

The way I have it set up:

Player Table, Draft Table, Draft Order Table (because in my situation
it would be as if a draft can have 2 or 20 or 100 players chosen..no
set number) where Player.College=Draft.CollegeMatcher (where
CollegeMatcher is the selection field for the college above the left
portal) and Draft.DraftID=DraftOrder.DraftID

the main layout is in the Draft Table, with the left portal using the
Player Table and the right portal using the Draft Order Table.

I tried setting up a relationship saying that Player.playerID =/
DraftOrder.playerID, but it didn't work. The two portals in the Draft
Table layout seem to not communicate with each other.


Any ideas?

EP

On Apr 9, 10:25 am, "EP" <ericp... (AT) gmail (DOT) com> wrote:
How are you currently adding a players ID to the draft order table?
If you script it, say have "Draft" button on the portal layout, you
can create a field named "Drafted" and when your script 'drafts' a
player, it sets that field to the current year (or whatever the unique
id of the record of the Draft table is).

Then you add a bit to your relationship between Players and Draft,
namely

Players:rafted =/= Draft::Year

You can play around with this idea to meet your needs. Like if this is
for a fantasy league, it might make sense to set Players:rafted to
Players:rafted & "P" & Year so you won't delete the draft history of
a player. You can then flip back and see who wasn't drafted just by
looking at the left portal.


=/= is not equals.
"P" is a pilcrow/paragraph symbol