Forum Discussion
Solved
Combobox goes empty on new record
Hi all - silly issue that somehow I can't get the answer to. Any help is appreciated. I have an Access database (dataverse backend). I'm using a data entry form, which works well. There are a varie...
- It's not the only way to handle the situation. However, it is the appropriate way for a relational database application.
ah I see, you mean simply a related table with those unique risk name as values? Yes that would be better from a design perspective. Initially this field started live as a sort of free type field , later on with some grouped functionality on the risk name.
If that's the only way around it I may have to do that indeed. Bigger implementation job than planned. There's no other hack you can think of?
If that's the only way around it I may have to do that indeed. Bigger implementation job than planned. There's no other hack you can think of?
It's not the only way to handle the situation. However, it is the appropriate way for a relational database application.
- You're absolutely right. I was implementing a short cut that would have resulted in long term pain. I created a table for the risk names.