Click button to go to correct record
I've created a file which has two tables: customers and orders. I have created a form which allows me to navigate to the correct record. The idea being click customer and it shows me their details and all they have bought.
I have used a portal to pull in records from the orders table which matches client_ref_no then gets client_order_no. I end up with a list of say 5 orders for my 1 client. I want to be able to click a button and look at the specific order for that client.
I can get the list to show no problem, when I click the button beside the record it only ever goes to the first order for that customer and not the specific record.