Hi,

 

     I would like to make a search form based on some data imported from excel.

 

(1) I have imported the excel data via the excel migration tool but I cannot find the data anywhere (although there was a message to say that data has been uploaded successfully)

 

(2) How do I link this data to my search form? I can't use the lookup form field right?

 

Example of the search form:

 

Year :       (to be able to select year from dropdown)

Class: 1A, 1B, 1C (etc corresponding to the year)

Name of Pupil : XXX (corresponding to the year and class they are in)

 

So if I want to find a student from a particular class in 2010, I would first need to select 2010 from "Year", followed by their "Class" and then a whole list of pupils' names will appear.

 

Any idea how to do this? I'm an idiot when it comes to scripting as well... Help needed!!!!!!

 

Thanks in advance!!!!!