Page 1 of 1

small database

Posted: Fri Apr 06, 2007 8:20 am
by maninjapan
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.

Posted: Fri Apr 06, 2007 8:25 am
by feyd
Can you post the table structures and how they are supposed to interconnect? Post your query too.

Posted: Sat Apr 07, 2007 1:14 pm
by califdon
Do you have some test data entered in the tables?

As Feyd said, you have to tell us what your query looks like before we can determine what's wrong.