small database
Posted: Fri Apr 06, 2007 8:20 am
Hi
i am trying to make a small basic database for a friend. However, I am stuck whereby I have to add three different materials for the paper, all of different percentages.
this is the first
table materials
material_code primary key
material_name
table products
products_code
products_name
products_mat1
products_mat1amt
products_mat2
products_mat2amt
however when i try to use the code to display the product_code, product_name, product_mat1 (as material_name)
it comes back as blank?
any ideas to help navigate this?
just trying to find code now.
i am trying to make a small basic database for a friend. However, I am stuck whereby I have to add three different materials for the paper, all of different percentages.
this is the first
table materials
material_code primary key
material_name
table products
products_code
products_name
products_mat1
products_mat1amt
products_mat2
products_mat2amt
however when i try to use the code to display the product_code, product_name, product_mat1 (as material_name)
it comes back as blank?
any ideas to help navigate this?
just trying to find code now.