sometimes the invoice number wil be in text field 1 or in text field 2
Why would that ever be the case? What problem do you solve by using two different fields in the same table for the same ID number?
Or am I misunderstanding your description of your database design?
I imported the Bank Transactions from a text file . My bank separates Date ,Bankcode, amount, textfield 1, textfield 2, textfield 3 etc
Will it be better to combine the text fields in one field?
I'm not suggesting anything yet. I'm just trying to understand the nature of the problem.
If the Invoice # appears in Field 2, what data is found in Field 1?
What would be nice is if we can set up a calculation field in your Bank transactions table that correctly identifies and extracts this invoice number from amongst the other data appearing in these same fields...
List ( Field1 ; field2 ) is one possibility, but I'm hoping for something a bit less "messy" if it's possible to set up...