var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Beginner - Hear about us section
I am a beginner. I have to design a table Where i can put all my categories like
Hear About Us -- Radio,TV, website
Ethnic Orign -- blck, white....
How to design a table to hold these categories
I wouldn't try to put them all in one table - that would be the dreaded "one true lookup table".
create table media (medium_code varchar2(5) primary key, medium_name varchar(30));
insert into media (medium_code, medium_name) values ('TV', 'Television');
create table ethnic_origins (eo_code varchar2(5) primary_key, eo_name varchar2(20));
insert into ethnic_origins (eo_code, eo_name) values ('BLK', 'Black');
display them on a form (in sections Hear about us, Ethnic Origin)
Thanks for the reply,
I want to display them on a form (check boxes) so that a user can select.
like i said in the last post.
cat_id, cat_name, cat_type
1 tv hear_about_us
2 radio hear_about us
3 white ethnic_origin
4 black ethnic_origin
Cant we use like that
Last edited by sureshid4dbdesign; 01-08-10 at 07:27.
No, you didn't mention forms or checkboxes at all in the last post!
Originally Posted by sureshid4dbdesign
So, you have decided to go for a OTLT anyway. Fair enough.