AnsweredAssumed Answered

Click button to go to correct record

Question asked by jackmac on Jul 26, 2012
Latest reply on Jul 26, 2012 by philmodjunk


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.

Any ideas?