Combine 2 tables and have extra fields (1 Viewer)

[Nevsky78]

Hi,

I'm working myself into a right lather trying to work this one out.

I have a table with Item Data - tblCLPForecastFeed. I also have Customers who forecast against various Items on the tblCLPForecastFeed. The customer table is called tblCustomerList

This is probably far more simple than I am making it but how would I be able to create a "super-table" (or query) where I can allow Forecast Data to be input? The Forecast fields would be QTR 1, QTR 2, QTR 3 and QTR 4.

One customer can forecast many items and one item can be forecast by many customers.

However, I want the table, or query, to have all Items and all Customers on there.

I've attached the file. The qrySuperTable gives you some idea of what I'm aiming for.

Thanks,
Nick

 

[Guus2005]

You need a link between the two tables. Otherwise you get a cartesian product. Which means that the result set of records is the first table times the second table in your case 1494 x 82 records.
The result doesn't mean anything.
So perhaps you're missign a table.

HTH