by sini » Wed Oct 10, 2012 5:27 pm
TabelB is a client list with all clients
TabelA is a table with only codes of some clients, say tax clients
I have a form based on another table, but want to select a client from a valuelist, which must only show tax clients ( tableA), but the description, 2nd field, is from the tableB, the return field is the code.
when I create the valuelist on tableB it shows all clients
when I create the valuelist on the relation tableA_to_tableB, it has the problem
If I could select the fields to show from the relation, it would be great, but I can only select fields from one table
if I set the relation tableB_to tableA, then I cannot select the field from tableB in my valuelist and it will then show ALL of the clients