Hey folks..
I have a table filled with caterers... who have entered their information into my db. I used a lookup table for the state name. So, Florida is state 12, Texas 55 (i included Canadian provinces) and so on...
Now that I wish to display the caterer records... all i show is Mickys Catering, Miami, 12 not Miami, Florida.
How Can I rectify this?
Any suggestions?

I am using Dreamweaver MX. SQL Server, and my 2 tables are called 'caterer' and 'ref_state'

Thanx!
Richard

You've Been Blasted by King Richard