How do I stop duplicates happening when I have linked some information from another table?
Scenario - I am displaying a list of invoices, which you can expand to see some of the detail of each item on that invoice.
The invoices are stored in the move table, and are grouped by number22 (invoice number in my software)
The users full names are stored in the base table, the user pin no. in the base table is number1, and we also stamp the user pin no. into the move table against the invoice in number28. The user full name is stored in string1 of the base table.
So I attempted to bring in the full name (string1) from the base table where base.number1 = move.number28, but then it brings back an unlimited amount of rows instead of the 3000 odd there are.
You can see me trying this in the video below
