GSquared (3/26/2009)
You could put the level range and level step in the join table.Thus, if the recipe goes from level 10 to level 25, but only has 10, 15, 20, 25, you'd put range 10-25, step 5. If it goes 10 to 25, but has versions for every level in that range, you'd put step 1.
Does that help?
Ah. Hadn't thought of doing it that way. Yeah, that will probably work.
Bruce W Cassidy (3/26/2009)
[font="Verdana"]So long as you are happy writing the SQL, then joining the additional tables should be fine.You can create views that already have the joins done to simplify things if you wish.
[/font]
heh. Views. Haven't tackled those yet. Once I get the structure figured out and the data imported to where it needs to go, I'll be playing around with views. And probably asking questions.