Click here to Skip to main content
15,887,027 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
AnswerRe: Thoughts On Handling Exceptions in This App Pin
jschell4-Oct-23 4:41
jschell4-Oct-23 4:41 
AnswerRe: Thoughts On Handling Exceptions in This App Pin
trønderen4-Oct-23 9:21
trønderen4-Oct-23 9:21 
QuestionContainer orchestration with primary and secondary failover Pin
pkaelin18-Sep-23 9:47
pkaelin18-Sep-23 9:47 
AnswerRe: Container orchestration with primary and secondary failover Pin
Gerry Schmitz19-Sep-23 17:17
mveGerry Schmitz19-Sep-23 17:17 
QuestionNot Sure How To Make This Change Pin
Kevin Marois11-Sep-23 11:04
professionalKevin Marois11-Sep-23 11:04 
AnswerRe: Not Sure How To Make This Change Pin
Mycroft Holmes11-Sep-23 12:01
professionalMycroft Holmes11-Sep-23 12:01 
GeneralRe: Not Sure How To Make This Change Pin
Kevin Marois11-Sep-23 13:07
professionalKevin Marois11-Sep-23 13:07 
AnswerRe: Not Sure How To Make This Change Pin
Richard Deeming11-Sep-23 21:49
mveRichard Deeming11-Sep-23 21:49 
As Mycroft said, stuffing every lookup into a single "lookups" table is a bad idea. It makes life much harder when you want to evolve a single type of lookup.

Start by moving the employee types to its own table. The next step will depend on your precise requirements:
  • If you only ever want to report on a specific group of employee types, then replace the AppCode with a lookup to an "employee type group" table. When the user adds a new employee type, let them select the appropriate group, so that those types can be included in the relevant reports.
  • If you need more flexible grouping for your reports, add a many-to-many relationship between the employee type and the employee type groups. You can optionally let the user add the new types to one or more groups; if they don't, then those types won't be included in the reports.




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

AnswerRe: Not Sure How To Make This Change Pin
jschell12-Sep-23 4:51
jschell12-Sep-23 4:51 
AnswerRe: Not Sure How To Make This Change Pin
Gerry Schmitz12-Sep-23 5:06
mveGerry Schmitz12-Sep-23 5:06 
QuestionWhere To Store Configuration File for This App Pin
Kevin Marois6-Sep-23 12:45
professionalKevin Marois6-Sep-23 12:45 
AnswerRe: Where To Store Configuration File for This App Pin
Gerry Schmitz6-Sep-23 19:33
mveGerry Schmitz6-Sep-23 19:33 
GeneralRe: Where To Store Configuration File for This App Pin
Kevin Marois7-Sep-23 5:26
professionalKevin Marois7-Sep-23 5:26 
GeneralRe: Where To Store Configuration File for This App Pin
Gerry Schmitz7-Sep-23 6:04
mveGerry Schmitz7-Sep-23 6:04 
AnswerRe: Where To Store Configuration File for This App Pin
Richard MacCutchan6-Sep-23 21:45
mveRichard MacCutchan6-Sep-23 21:45 
GeneralRe: Where To Store Configuration File for This App Pin
Kevin Marois7-Sep-23 5:28
professionalKevin Marois7-Sep-23 5:28 
GeneralRe: Where To Store Configuration File for This App Pin
Richard MacCutchan7-Sep-23 5:53
mveRichard MacCutchan7-Sep-23 5:53 
GeneralRe: Where To Store Configuration File for This App Pin
Kevin Marois8-Sep-23 5:51
professionalKevin Marois8-Sep-23 5:51 
GeneralRe: Where To Store Configuration File for This App Pin
Richard MacCutchan8-Sep-23 6:13
mveRichard MacCutchan8-Sep-23 6:13 
GeneralRe: Where To Store Configuration File for This App Pin
Kevin Marois8-Sep-23 7:29
professionalKevin Marois8-Sep-23 7:29 
GeneralRe: Where To Store Configuration File for This App Pin
jschell8-Sep-23 7:55
jschell8-Sep-23 7:55 
GeneralRe: Where To Store Configuration File for This App Pin
Richard MacCutchan8-Sep-23 8:01
mveRichard MacCutchan8-Sep-23 8:01 
GeneralRe: Where To Store Configuration File for This App Pin
Gerry Schmitz8-Sep-23 8:20
mveGerry Schmitz8-Sep-23 8:20 
GeneralRe: Where To Store Configuration File for This App Pin
Dave Kreskowiak8-Sep-23 9:24
mveDave Kreskowiak8-Sep-23 9:24 
AnswerRe: Where To Store Configuration File for This App Pin
jschell7-Sep-23 5:11
jschell7-Sep-23 5:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.