Getting FM DB to recognize new values

[scottvaughan]

Is there a way to get fileMaker to recalculate everything based on a changed value? For example, i have a sales report I just put together. I have used data from a db that already existed but did not have salepeople listed. I have since created a Salesperson field. the report should show a list of all of our jobs including customer and sales person. All of the records that existed prior to the addition of the salesperson do not show the sales person. I have to manually slect the name. It works for all new work.

[Jeff Bills]

Is there a relationship between two tables based on a salesperson?

[scottvaughan]

No, It's a lookup table based on customer.

[Jeff Bills]

How many records are you dealing with? You could choose RECORDS > REPLACE FIELD CONTENTS in any given found set