Jag skriver detta inlägg på englska, så att alla kan förstå mig... :)

Hi there!

I want to change my current moviedatabase (MS Access)to an SQL database, but instead of using only one table containing all the movieinfo, I wish to make another table with actor/director info only. How can I combine to different tables in asp, using the movieID from the movieinfo-table? For example, movieID 3 shall contain the actors Stallone, Carrey and Pitt. (The actors have their own ID from their own table). How can I print this out with my RecSet? Is this very tricky?

Please help me...

FreOHag

Finns lite trådar om det sedan tidigare i forumet. Se bland annat: [Novisfråga: ID VS Namn i Access]