Finding records

Discussion created by TC on Jul 6, 2012
Latest reply on Jul 6, 2012 by TC

I have a layout that has a dropdown box that dymically uses values from a field - That works

I have a portal that displays associated records from the value picked from the dropdown box - that works


The problem is that the value chosen in the dropdown box also changes the field value of the active record of the table used in the dropdown box (usually the first record)


So I have a table of routes (A, B, C) used as the lookup values in the dropdown box. and

Customers 1, 2, 3 for route A

Customers 4, 5, 6 for route B

and Customers 7, 8, 9 for route C


If I choose Route A, Customers 1, 2, 3 are displayed in the portal. If the active record is A, then A is changed to A, but if the active record is B, then B is changed to A


What am I doing wrong or can this be done this way. If not, any suggestions