I have the folloowing tables in the database
tblCD/Main: CdID - autonumber, CDName - text ...anything else will be a lookup field that we will get from another table, so we will come back to this table
tblAuthorType - AuthorTypeID - autonumber, AuthorTypeName - text. author type name will...