Need to populate a new field with data from another without having to edit the record

I don't know that I have this set up the best way. I'm just guessing.

I had to create a summary report in a second table (Product List) to get the data we wanted the way we wanted it. Now I need to compare the data. To do that I brought the summarized data from the second table over to the first table (OOS Data). QB won't let me use them in a formula, I'm guessing because they are numeric lookup fields. So I created the form rules to write the data to a text field. Then I used the text fields for my formula.

Form rules will not work for that so I suggest that you kill the form rule and get the formula working.

The formula works. I just need the field to automatically populate. I don't want to edit the records to get it to populate.

I spoke to Stephanie on the phone and sorted this out.  Stephanie's main issue is that she needed to combine information on multiple records for the same Ticket# into a formula field.  That required setting up a table of Unique Tickets and Stephanie remembering to copy across a summary report of the unique tickets to the Unique tickets table after each data import.