2. Production Rates
3. Time Cards
Each time card created has a "reference field-Job Number" that comes from a table called Production Rates. Though this may seem off, There is a reason I have it come from Production Rate rather than the Jobs table. For a reporting purpose, I have created a relationship from my Jobs table to the Time Cards table. The standard relationship works, but I am unable to create summary fields because the reference is Production rate table lookup field called Job Number.
To make things simple.....does anyone know if there is a field I can add to my time cards table, that takes the job number lookup field that is already in time cards, and copies it as a value. Maybe call it Job number 2. I tried just adding one that equaled the other...but it still saw it as a lookup of the lookup. It might need to be some formula that took the absolute value and copied it over. To make things even more difficult, my job numbers have letters and numbers. ( example - 136342-TC)
Thanks in advance!