K10DJIM
Good advice above. Like yourself I use a K10D and I have the SMC A 100mm 2.8 macro. I like this combination a lot. Here's a hand held shot from last summer:
The M 50mm f4 is also very good and a lot cheaper. Good luck with your macro search.
Tom G