I am pretty new to zoho and finding it an impressive tool. Trying to familiarise myself with creator and I am trying to build a complex database and I have a form that i want to capture maltiple values by importing data from another form using the look up facility.

For instance, lets say I have a sports event where I want to select 6 players from a list of players in a squad. I have created 6 fields representing each player and I am using the lookup field to find these players from a player list. I currently have the form doing this and it collects the data and inputs into the table and is viewable on the form_view function however when I want to retrieve the data from the form, it seems that it only records data from the 1st lookup field. I guess it requires a basic script. Can anybody please give me a little feedback on how I might be able to collect all the data correctly.

Also, when I select a player from the player list in the first look up field, is there any way that I can eliminate that player from the list for the additional look up fields to avoid duplicatiuon.

Appreciate your help.