I don't know how explain exactly what my problem is, in regards to designing a database & to link it to my page (ASP).
Here it goes:
I have a structure like this:
- Shower Unit
- Multi Point Unit
under Shower Unit
-- AQ Series
-- DD Series
-- DDC Series
inside each series, it has many photos inside, such as:
(for AQ Series)
--- AQ 35 E.jpg
--- AQ 45 E.jpg
(for DD Series)
--- DD 35 E.jpg
--- DD 45 E.jpg
--- DD 60 E.jpg
How can I do the design of it or what is the best design I can do for it.
I have a table named: STEProd, and the Field Names are ID (Auto#), Series, Photo, Link (Optional).
If I put the series for example AQ 35E under the series, and the path of its Photo, how can I link it to the web (ASP). Is it <img src="<%=rsSTEProd("Photo")%>"/> ? But it'll show or run continuously until the end of the database. what i want is if it's for AQ Series, it will show the photos of AQ 35E & AQ 45E only. So if 1 series have many photos inside, it doesn't matter, the only thing is I want the photos by each series to be shown.
I have on my mind, to create a Table for each series. What do u think?
But I'm searching for other opinion or advise from EE.
Thank you & wait for EE's reply then....