Hi Everyone
this is a screenshot of part of my customer table. It shows 4 fields - although only three are key.
There are two tables: Customer and Employee. I have added a dropdown control which looks at the Employee table and the Full Name field. . I would like two things to happen.
When a new customer is created, the user will pick a name from the list (highlighted yellow) and then the relevant information will be pulled in to the two other fields (highlighted with a red cross)
However, I can not get over the first hurdle!
When I add a new record, and choose the relevant data from the dropdown, the record does not save and reverts to (I think) the first option!
I have added the following to the Update property: DropDown1.Selected.'Full Name'
If you can help in any way to solve this issue.
thank you


Report
All responses (
Answers (