it is better (and a more correct way to design your database) to have the brandID and ProductID stored.
the brandName and productName are defined in the brand and product tables
they should not be redifined in this loc_locations_new table. by using the ID's instead, you are properly normalizing your data which the goal of a relational database.
to return the brandName and productName associated to the ID's stored in the loc_locations_new table, you would use a joined query.
see the following page for more details on join queries:
sql_join.asp