Relationships and Value Lists changes contents of fields, help.
Not quite sure what I have done, or how I have done it, or even how to explain, but here goes....
Admin asked for multiple addresses to be assigned to each client, and then the ability to select the relevant address when raising a delivery note.
So I have added an additional table for addresses, and linked it to the clients database with a relationship.
I have then created a drop down on the delivery note layout using a value list created from the company name field on the new addresses table.
Everything seems fine, but when I go to print the delivery note, it will change the content of the company name field on the first address assigned to that company to the company name selected from the drop down. And then use the first address from the drop down with the changed company name.
I'm sure I'm doing a pretty bad job of explaining this, I have attached a couple of screen shots.