Field won't update at all

[Tech_knowledge]

I have two seperate tables I can't get one field in the first table to update properly based on a field in the second table here is what I'm trying to do exactly in the Table 1 I have hours and everyone starts out with an initial 250 hours now in Table 2 a ticket is made and if that ticket takes 5 hours then I want that amount subtracted from table one and I can't get Table one to update at all I have a relationship going from one table to the other the field are as follows in Table one it's a number and the one in Table two is a calculation any help at all would be appreciated.

[comment]

I am guessing here, as your description is rather sketchy:

TABLE1 (people?):

PersonID

TABLE2 (tickets)

TicketID

PersonID

Hours (number)

The relationship is:

TABLE1::PersonID = TABLE2::PersonID

In TABLE1, field cHoursLeft (calculation, result is number)=

250 - Sum ( TABLE2::Hours)

[Tech_knowledge]

No actually what I have is this

TABLE 1:

Package Hours: 250

TABLE 2:

Hours Used: 6

I want the Hours Used to be subtracted from the Package Hours so you end up with 244 hours remaining and I can't get this done to save my life.

[whitemyer]

What is the relationship between the 2 tables?

[comment]

The same question, and another: TABLE1 is table of what?

[Tech_knowledge]

Table 1 has customer information such as first name last name address and so on

and the relationship is between last names

[comment]

It's the same answer as above: create a new calculation field in TABLE1, with the following calculation:

Package Hours - Sum ( TABLE2::Hours Used)

Incidentally, two or more customers can share the same last name, so it's advisable to base relationships on serial numbers instead.

[Tech_knowledge]

Thanks guys that advice worked perfectly