Recent content by funk88

ProductType (3-5 records) ProductCat (20-30 records – could increase in the future) QualSpec (currently about 100 records – will increase in future) UnitsOfMeasure (probably about >30) QualQuant (2 records) TestProcedureNumber (currently about 50 records) – this will probably need to be...

OK... I did some restructuring of my tables. I moved the TestType data to the Test table. I still need to create a lookup table for a list of possible qualitative specs. However in an earlier post you stated: Tables with 1 real field (autonumber primary keys aren't real data fields). You...

The TestType is unique to the analysis. For example, consider these product - test -test type combinations: Product A - pH - neat pH Product B - pH - 5% aqueous pH Product C - pH - 30% IPA pH Each product has the pH test but the method that the pH is analyzed is different in for each...

Plog, You are correct the tblProductTestJunct will create the test plan (all of the tests required for each product) and tblSampleTest will hold the result information. Dividing the database into two parts makes a lot of sense and looking at it in this way seems to simplify things...

Thank you Plog. I will try to clarify my project for you. 1) I have inserted notes in my fields to clarify their purposes. 2) I intended to use these tables (tblProduct, tblTest, tblTestType) as lookup tables to construct the test plan for each product 3)This is the area I am having the most...

sneuberg - Thank you for the test file. Still did not work on the problem PC. However, this problem is solved! I ran a Microsoft update and installed all updates for Office. The images now appear. For clarification this issue was on a Windows 8 PC with Access 2013 32bit installed...

Yes the images can be seen in both explorer and paint.

I have a database with reports that print labels. These labels have images that are pulled from a drive location on a network drive. Out of four PC's there is one that will not print the labels with pictures. The pictures do not show up in either print preview or in report view on that one...

This is quite frustrating. I thought I was having some success but now I just have a big mess. I guess I just do not have a full enough understanding of table relationships to make this work. I will keep trying. I have attached the latest version of my test database. Thank you for any help you...

Thank you so much 'The_Doc_Man'. I have created the following tables: tblProduct (product names) tblTest (test names) tblProductTestJunct (junction table for matching tests to each product) (fields are 'ProductID' (PK), 'TestID' (PK), TestType...

I am in the planning stages of a database that will store testing results for products. Each product will have a set of tests (test plan) performed on them. The test plan will be different for each product. Each batch of product produced will have all of the tests from that products test plan...