flash and access database(s)

I'm very experienced with Flash on the animation side, but I am now trying to teach myself the programming side, which I am very new to. My situation/questions is/are this:

I am building a Flash website in which the user selects from a drop down menu in Flash, and that sets a variable I called "tname"(so far this is working fine). I want to be able to have an Access Database set up so that depending on what name is selected, the same set of variables (tpiclink, tage, taddress, etc.) are returned with the values depending on the "tname" variable.

So far, I know how to access varibales from Access databases. So, my questions are these:

1. How do I set up an access database with similar fields but multiple entries for them (ie, address, age, etc. are the same, but these work for multiple names)?

2. Do I need only one Access database or one for each person?

3. How do I send the variable tname from the Flash file?

4. How does the ASP file read it, then send it to the Access database (keeping in mind that I know only fairly basic ASP commands).

5. Is there anything I have overlooked throughout my "quest" to make this work?


Thanks in advance.
The N Man

umm, by definition thats what a database is!
field 1--field2--field3--field4
record1
record2
record3



definitely NOT one per person!
if you want to think of the database as a box, then its the big crate/palette that gets sent in delivery truck - the TABLES are the boxes, and the FIELDS are the content of those boxes.
Use multiple tables to break your information down into suitable chunks so that you arent duplicating data - its called normalisation.
i.e. three tables-

table1

Customer_ID Customer_name Address Tel_No
record1
record2
record3

table2

Order_ID Product_ID Customer_ID
record1
record2
record3

Product_ID Product_Description
record1
record2
record3

here the Customer_ID, Product_ID and Order_ID are 'keys' and can be used to reference the other tables, like get all Order_ID's from table2 where Product_ID = whatever.


look here for an explanation (albeit it incomplete)
macromedia's site is also a good place for this.

i know nothing worth talking about in relation to ASP so....there are more tutorials out there for flash/asp than there are for flash/php for some reason



GOOGLE

hope this has been of some use.