I`m having som trouble viewing the data I want to.
I have 2 tables, tblserial and tblparts, in the table tblserial I have a list of products and in the tbl parts I have a list of the parts the products are made of. There are 4 "projects" that theese products and parts belong to. i`m using a "project index" tocontrol which project I want to work with, they have the simple numbers 1,2,3 and 4.
all the projects consist of the same parts and products with the same serial numbers. I have a form with two combo boxes where in the first one I select the project I want to work with and in the next combo box there are a list over the products, when I choose a product and click "ok" I get a list over the parts the product is made of, all this works just fine BUT when I only have 1 project in the table, when I register more project with their parts and products the trouble starts.
If I choose let`s say project nr1 and a product I get a list og the parts the product are made of but I get a list of the parts in all 4 projects, not juts the one I chose. there is one thing that separates the parts in the different projects and that is a status which is different for the same parts.they have a different value in the different projects. How do i fix this??(sorry for the LONG post)
I have 2 tables, tblserial and tblparts, in the table tblserial I have a list of products and in the tbl parts I have a list of the parts the products are made of. There are 4 "projects" that theese products and parts belong to. i`m using a "project index" tocontrol which project I want to work with, they have the simple numbers 1,2,3 and 4.
all the projects consist of the same parts and products with the same serial numbers. I have a form with two combo boxes where in the first one I select the project I want to work with and in the next combo box there are a list over the products, when I choose a product and click "ok" I get a list over the parts the product is made of, all this works just fine BUT when I only have 1 project in the table, when I register more project with their parts and products the trouble starts.
If I choose let`s say project nr1 and a product I get a list og the parts the product are made of but I get a list of the parts in all 4 projects, not juts the one I chose. there is one thing that separates the parts in the different projects and that is a status which is different for the same parts.they have a different value in the different projects. How do i fix this??(sorry for the LONG post)
