I've set up a relationship between a time cards table and the service items table. Service Items to Time Cards is a one to many relationship. IOW, there are many time cards to a service item. Each service item is billed out to clients at a different rate. I'm trying to calculate the client's bill based on time * rate. The problem is that the related item (in the time card table) is not getting updated and therefore, there is no rate to multiply by the time.
Can anyone help with what I've done wrong or what do I need to do?
In other words, when a record is created in the Time Card table, the field must be populated with the value of the Key Field in the pertinent parent record of the Service Items table. That is how the parent and child are linked so you then get your data in the summary fields.
So my questions are:
What is the Key Field in the Service Items table?
How is the Service Item parent identified in a Time Card record?
First, make a complete back up of your application. Make sure you include the Record ID fields as they are not typically a default field.
Then, go to the field properties of the Service Item field in your Time Card table and change it to a "Look Up" field.
Once it is a Look Up field, in the Field Properties under Lookup field options | Reference Field choose the Related Service Item and the Value field is the Service Item. (I am guessing at these names based on your comments above.)