I want to create a database with a table called "FILMS" in this table i want the "GENRE" to be calculated. Ie if I type in the letter "A" when creating a new record it should be replaced by the word "ACTION", others include:
V for ADVENTURE
N for ANIMATION
C for COMEDY
F for FAMILY etc............
I want to implement this into the CREATE TABLE statement. can someone please help me out?? I've heard of something called a lookup table and concatenating but i dont know how to use them??