Can you link tables based upon a formula result? I have 2 tables: FINA_ALL and AR. I need to link the two tables based upon Invoice #. AR contains the field Invoice#. FINA_ALL has a field TRANS_TEXT which is a combination of the customer code and invoice#. I can extract the invoice# by using right(TRANS_TEXT,6). How can I link the result of right(TRANS_TEXT,6) to the AR Invoice# to retrieve additional details from the AR table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking tables based upon formula result
- Thread starter stoopers
- Start date
- Thread starter
- #3
I believe I may have a date issue as well. This issue occurs when we make a journal entry to accrue Revenue that occured during the month but the invoice was generated after the month end. The invoice date does not match my record selection date.
- Status
Similar threads
- Question
- Question
- Locked
- Question