Hi all I am new and learning the program. I was having alot of problems with lookup wizard. It was not lookup wizard that was the problem. It was tables not being setup.
Now I am able to make a drop down list of all 50 states. I am also able to make a drop down list of cities for a State.
I am trying to have my visitors have a drop down list for States then they can pick the State they would like in.
From the state they want to look in they have a drop down menu of the cities in that State.
From there a list of the knife businesses in that city will show up in the table on the website.
Where would the dropdown menus I make be located on the page. I didn't not figure that because I still have problems with the lookup wizard that I hope you can help me with.
As stated I can get a dropdown list of states and cities, but I can't get category control and category field to work. I put in state ID in category control, but the category field has crazy things happen. I can put state in the category control I have the option of state and state id it will not work. If I put LA cities the only choice is city name in the category control. state is the only thing that shows it the category field. I thought I may need to do master detail relationships. I tried that and I put the table state and the table LA cities to make a relationship and I get a blank in primary key.
This is not like products. in products you may have a customer purchasing more than one item and the customer would have a relationship to a number of items.
I can't figure out have to do a relationship with my tables. I have states and statesID in that table and it the LA cities I have City and Cityid in that table. I am doing Louisiana cities because I am from LA. I think I will have to make a table for all State cities. I think my problem is not with code or lookup wizard I think I don't understand how to make my tables.
Would I need to have a column in each table that will match. Like Order ID for the sample.
I would be glad if someone can help me. I am new and would like to learn the program.
Do you think the program is worth the money and can you do anything you would like with the program as for as php goes.
Thanks