The [CustomerInfo] table relates to [Products] through the CustomerID field.
The [Products] table relates to the [Inventory] table through the ProductID field.
My [Inventory Table] consists of three fields, CustomerID, ProductID & Quantity
My objective is each time I add a new product in the [Product] table (or through a form), I want to add a record for every customer in the [CustomerInfo] table to the [Inventory] table to show they have a 0 quantity of the product, and I can do some calculations from there...
Am I approaching this all wrong? I'm thinking I need to approach it with an Append Query, but have no idea how to tell Access what I'm wanting to do. Any thoughts, comments are 100% appreciated.
Sounds to me like your design is wrong, but it's impossible to say since you haven't given us your goals... what you want to achieve with the entire database. It is also impossible to tell what your structure really is... can you post your ERD?
Yes, I think you're after an APPEND query. However, there are a number of concerns I'd have over your ERD, but I don't have time to get into specifics atm.
Basically, I am always concerned when I see Fieldname1, Fieldname2 etc... it usually indicates a bad relationship, a 1 where there should be an M. Also, I see no reason for the 1:1 relationships.
To move ahead with your append, make a query that gets all the records you want to add, use a calculated field for those zeros. When you can see the data you want to add, turn the query into an Append Query, select the destination table and match the fields up.