I am trying to use Zoho for my WW2 campaign for a video game called Red Orchestra. I like that it can be integrated into a website easily. I am new to Zoho and have some questions,

First form,

The first form that I created is called "Axis_War_Room_Data".

1.Division

2.Unit Name

3.Infantry

4.Halftracks

5.PzIII's

and so on.

Is there a way to link the input, say for PzIII's, into a 1 line in a spread sheet? I want a spread sheet to look like this

Infantry [600] PzIII's [34] and so on from the data entered in from the sheet above.

2. Form 2: Unit_Deploy_Menu

I need to grab information from  "Axis_War_Room_Data" entries. I basicly want a drop-down box of the available units. Example:

1. Division: (Drop-down of the avialble Divisions Entered in values from"Axis_War_Room_Data"/Division") 1st SS Panzer/2nd SS Panzer/12th SS Panzer and so on.

2. Battalion: (Drop-down menu of the info input from "Axis_War_Room_Data"/"Unit_Name" entries) So if the user picks "1st SS Panzer", it shows in the drop down menu the Unit names for that Division.

I would like the coding or step by step on how to do this or anything that could be helpful.

Thank you,