A couple of questions

[Snak9r]

Hi all,

I'm currently stuck with 2 issues with my database.

1) I have Team (TeamID), Player (PlayerID, CurrentTeamID) & Transfer (TransferID, PlayerID, PrevTeamID, NewTeamID) tables. I got this addTransferRecord form to add transfer records. The Player table has a currentTeamID attribute which is a foreign of TeamID from Team table.

What I'm trying to do is when adding a transfer record via a form and after selecting a particular player from the combobox, I want the prevTeamID combobox.Value to automatically reflect his currentTeamID. Next, after choosing his newTeamID from the combobox, I want the value to be stored in his currentTeamID.

*CurrentTeamID, PrevTeamID & NewTeamID are foreign keys of TeamID

2) I have this LeagueStandings (TeamID, Wins, Losses) table. I've added an expression into the query to calculate the PCT (those basketball fans would know what i mean ). The thing is I've been trying to find a way to sort the position and assign rankings to each team where PCT is descending.

Thanks for the help in advance

 

[Snak9r]

I think I might have posted in the wrong sub-forum. Should've gone with the Forms forum. Can someone move this? Thanks

 

[Snak9r]

Nobody? If anyone requires my file, I could post it.

 

[informer]

Hi Snak9r

To help you, could you:

1. Explain your functional needs, it means without considering technical database problems?
2. If you have already developed something, post it too?

 

[NauticalGent]

Informer, unless someones calendar is way off, I think Snak9r has moved on...

 

[informer]

You are right NauticalGent

Thanks

 

[NauticalGent]

It is kind of sad that no one answered his very basic questions. This Forum must have been very different back in 2007...

 

[NauticalGent]

Interesting. I look at New Posts almost everyday and, just like you, look for posts with 0 replies.

Not that I can answer most of them but I guess I feel that asking for help and not even getting a "re-phrase you question into something coherent" is dis-heartening.

I have always been amazing and impressed with how quickly and accurately MOST of my requests have been handled. I have had one ignored (over 500 views) and even had one guy tell me that my post was so bad he felt dumber for having read it... BUT... all in all, this site has been a fantastic resource for me.

One of the reasons I am a Gold Supporter.

 

[informer]

Sorry if I have initiated a sharp debate

 

[NauticalGent]

No worries, this isn't even close to a debate. There is some real sharp reading on this forum, especially in the water-cooler thread. Don't go there if you are prone to hurt feelings...you will leave gnashing your teeth and wringing your hands, crying for your mother. In that order...