well, you should not be storing both the brand name and the brand ID in the products table, you should only store the brand ID. the brand name will be defined in the brand table.
you can get the brand name back when displaying the product info using a joined query.
see the following page for details on using join queries:
sql_join.asp