So product lists: just the one "title" column containing on the different products. However, what would the productions lists look like? The relevant information for that list is date filled, quantity filled, and location filled, and product filled.
Since the title colum is required how do it use that in the ProductTypes list? Currently the title column contains numbers to be a "key" for each type of product listed. So record one reads: 0 in the title column, and wiget x in the Products column. Is my thought process wrong on doing it like this or is there a better way?
So SharePoint already gives you a unique identifier for each item in a list. It's called the "ID" field and is hidden from the view by default but you can surface that up in your view. My suggestion would be to utilize that Title field to hold what you currently have in your "Product" Column.
No problem! Happy to help. Another cool thing you can do with SharePoint is Calculated Columns which allow you to mash up data from different columns. For example, in your Products list you have your Title column which holds the product name (Widget X). And maybe you have another column for size (Small). You can create another column which is a type Calculated COlumn and have a formula which combines the Title and Size like so =CONCATENATE([Title]," - ",[Size]) . So your new column would have Widget X - Small. So in your Production list, you can add a Lookup Column to your Products Claculated column adn the user can select "Widget X - Small".
Moving this message so that it is at the top of its own post for discoverability. As a best practice, it's ideal to create your own post since your question may not be exactly as the original post.