I am a relatively inexperienced developer and need some basic help.
I would like to assign each sales order to an employee. I have made a new field, “Assigned” in table 36, Sales Header. I set the relationship for the field to the employee table. My only problem is that the field I want to stored in the Sales Header is the Search Name, not the employee number. How do I do this?
Note: Each Search Name is Unique
0
Comments
Bruce
I guess that I can connect using the employee primary key, then add another field to the sales header for the search name, but I did not want to add 2 fields. Any other suggestions?
Marcus
Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72
Marcus Fabian