I guess I should have mentioned that my client wants to avoid a child table/ mostly because they will be doing amateur queries and want to keep the structure as flat as possible. I MAY have to go that route (obviously the best relational soultion), but I promised them I'd try this first.

So...back to the question....

Thanks!