Where should I start?

[Vastedge]

Hey Everyone ... First off, I'm very new to all this.

Im making a forecasting database for the sales team. I have two tables.

Table One: Part Information (Description, Status, Salesman, Company, etc.)
Table Two: Part Revenue (Part ID from Table One, Month, Year, Actual Revenue, Forecast Revenue)

The best way to explain it is that right now I run a CrossTab Query that displays the part description as the Row Heading, the Month as the Column Heading and the Forcecast Revenue as the Values.

This creates a nice page for the salesman. He see's the part and a text box for all 12 months of the year where he can update the forecast.

Problem: You can't update a CrossTab Query

Please help. Note: I am a newb.

Thanks

Eric

[NeoPa]

It's true : You can't update a CrossTab Query.
I'm afraid you've hit a showstopper for that idea. What sort of help are you looking for (other than to confirm that's a problem)?

[Vastedge]

I'm basically looking for a work-around. To me this seems like a common way of designing a database.

How do I create a form that will allow me to do this?

Thank You

[NeoPa]

I'm pretty sure that any manipulation of the data to group items from multiple records so that they show in a single output record will cause difficulties with updating the returned recordset. Cross-Tab or aggregation (GROUP BY) queries are never updatable.
I can't think of a way to maintain the data without showing the items in their native form.