I have a table as follows

Name Id
Name

Is it possible on a single form to have 5 text boxes for Name and be able to add the data entered in these boxes to the table.

When I tried to do this last time as soon as I entered a name in 1 box the rest came up with the same name. I would like to enter the data in any order e.g maybe text box 5 then text box 1.....

Any suggestions would be helpful

You only have one field called name so you can only add one name into one text box per record. If you want five different names per record you'll need five fields, Name1,Name2 etc, which doesn't make sense. What exactly are you trying to do?

Thanx for your comments,

I need to select a football team on my form e.g. player 1 to player 11 to go into a table

Player ID
Player Name

At first I had my table set up as

Player ID
Player 1
Player 2
.......
Player 11

But this caused relationship problems, any ideas would be grateful.....as I say all I need is to be able to have the user be able to select 11 players on one form...I am trying to create a fantasy football site so every manager will choose 11 players, so I have other tables set up such as Manager, Team, PlayerDetails e.t.c.

[This message has been edited by JimmyM (edited 01-08-2002).]

Yes it's actually quite a complex set up. Each manager can pick a side for a specific date from a pool of presumeably say 20 players yeh?. So there are several one to many relationships between tables
TbleManager
ManID PrimKey
ManagerName

TbleTeamPool
PlayerID Prim Key
ManID Foreign Key
PlayerName

TbleTeamSelection
SelID Prim Key
PlayerID Foreign Key
TeamSelectionDate

Do your tables look something like that?

[This message has been edited by Rich (edited 01-08-2002).]

Cheers again

My tables are similar, I do not need to have a weekly selection though (not yet anyway) all I need is for a manager to pick 11 players, and them 11 players will be allocated points on a weekly basis.

Like I said earlier my problem is getting a set-up to enable me to have a form for team selection.

tables are

PlayerId
playername
playervalue
etc

TeamId
Teamname
managername

and the one below is the one I need to design for team selection

TeamSelectionID
Player
Team

so I would like the TeamSelection form to look similar to:

enter player 1 .........
enter player 2..........
enter player 3..........
........................
enter player 11.........

thanx