Forums

Hello All-

I am hoping someone can help me... I have a customer information form that collects a large amount of data, it is working fine and I know how to pull the data into connectivity. What I am wondering is if it is possible to create a connection that only grabs the customer names and puts them into a drop down list that you can choose from and when you choose a customer to have it then go to all of that customer's info.

If I were to list all of customers and their info on one page it would be a mile long. I know that I can set it to only list 1 on each page but then there is no way to get to a specific customer without paging through all of them. I am sure that this is possible but I am not a php or javascript expert so I am not sure where to begin.

Thanks in advance to anyone that can shed some light on the situation!

Hi arkmedia,

You can do this by adding a drop-down box in the Header of the Chronoconnectivity page and using the form result in a WHERE clause for the list. This is a bit fiddly but not too difficult.

However the drop-down is likely to be very long too . . . a better answer here would be an AJAX linked search box so that once you typed a few characters it would check the database table and show you a drop-down list of the matching results.

Bob