Trying hard to do a simple thing !

[jzwp11]

Is there a relationship between the machine settings and the tooling items?

Will each lot have a series of machine settings associated with it?
Can the same machine settings types apply to multiple lots?
Will each lot have a series of tooling items associated with it?


Can a tooling item apply to multiple lots?

[adevine]

Is there a relationship between the machine settings and the tooling items?
A. Yes the lot common denominator will be the lot#
Will each lot have a series of machine settings associated with it?
A.Yes
Can the same machine settings types apply to multiple lots?
A. Yes if they both passed QA
Will each lot have a series of tooling items associated with it?
A. Yes if they passed QA (for the report or querry)
Can a tooling item applie to multiple lots?
A. Yes

[jzwp11]

Looking back at the relationship diagram you posted, the tblSetupParameters is still not right. It has field names that are specific to either tools or machine settings. The specific tools or machine settings should be records in a table and you would relate them (assign them) to the lot of product with any applicable measurements.

Regarding your tools: cup size,cone size,cup gas,cup oxy, cup span

cup size, cone size imply measurements not a tool, so what is the tool a cup, cone? Do you have cups that are multiple sizes and do you select one of those to produce the product? Are the individual tools identified with serial numbers?

I have attached a sample database that I have worked up. Please take a look at the relationships and the contents of tblTools and tblMachineSettings. These two table just hold the names of the tools or settings. As you can see, I then link them to the lot of the product produced.

[adevine]

Yes you are correct; the tools are the cup and the cone. Each one has a dimension and a serial number, the serial number is what I will track and select one to run the product.

My ignorance is going to show here but I'm confused by the (logQCpass) and (longsettingvalue). Given the correspondence thus far am I "coachable"? The reason for the question.... I don’t want my ignorance to cause you extra work here.

Thx
Andy

[jzwp11]

logQCpass designates a logical (yes/no) field to record whether the QC of the lot passed (checked) or not (not checked). longsettingvalue is a long integer number field to record the machine setting itself used for the lot. Depending on that data, you may need a single or double precision number field if decimals are involved.

the tools are the cup and the cone. Each one has a dimension and a serial number

Is there only 1 dimension for each tool? If so, then you would include a field in the tool table for it. If more than one, then you would need a related table to hold the dimensions of the tool.