Query Relationship Problem: Need Help

[danz013]

Hi There,

I'm creating a sales system for my business. I've been doing pretty well so far however I need some assistance.

I have two tables.

Table 1: Includes details on my budgets for a particular product.

Table 2: Includes sums of my weekly sales, and also what the weekly budgets should be.

I've just created some querys sum up the sales for each week and drag them into Table 2. What I need to do now is drag the budget info into the table from Table 1.

Table 1 has a primary key called limit with a value of 1. There is only 1 record.

I want Table 2, to get the budget amount from Table 1 and add it to all records. (this info will later make a sales chart showing the weekly sales amounts against the budgeted expectations).

I've tried to make query to get the info from one table to another.

The update query takes the following format:

Budget Amount from Table 1 should be updated to the Budgeted amount from Table 2. The two tables are shown in the query relationship window and are linked by the primary key (the one that is equal to 1 - this figure of 1 is in both fields).

When I run the query, it dosn't return any results? Well, is returns the correct amount of fields, but all the fields are blank? I've been puzzling with this for the last 3 days. Any ideas?

 

[neileg]

Several problems here.

You are thinking in spreadsheet terms. You don't need to transfer data from one table to another. You group data together, perhaps in a query or a report, but you don't store it in multiple tables.

I suspect that Table1 has a column for every product. It should have a row for every product.

Not sure about Table2. Does it have a column for each product, too?