welcome to CF, Karyn.
Yes there is a way to do it. have you got any of the db built yet? if so, please post us your 'create table' statements so we can see the structure you plan to work with.
"The day you stop learning is the day you become obsolete"! - my late Dad.
Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
Useful MySQL resource
Useful MySQL link