Click here to Skip to main content
14,300,217 members

Design and Architecture

 
GeneralRe: Python-ic way of efficient TV player app architecture Pin
Richard MacCutchan28-Jun-18 6:54
protectorRichard MacCutchan28-Jun-18 6:54 
GeneralRe: Python-ic way of efficient TV player app architecture Pin
ninjaef1-Jul-18 21:36
memberninjaef1-Jul-18 21:36 
GeneralRe: Python-ic way of efficient TV player app architecture Pin
Richard MacCutchan1-Jul-18 21:53
protectorRichard MacCutchan1-Jul-18 21:53 
GeneralRe: Python-ic way of efficient TV player app architecture Pin
ninjaef2-Jul-18 8:47
memberninjaef2-Jul-18 8:47 
GeneralRe: Python-ic way of efficient TV player app architecture Pin
Richard Deeming28-Jun-18 7:44
mveRichard Deeming28-Jun-18 7:44 
GeneralRe: Python-ic way of efficient TV player app architecture Pin
Gerry Schmitz28-Jun-18 8:09
mveGerry Schmitz28-Jun-18 8:09 
AnswerRe: Python-ic way of efficient TV player app architecture Pin
Pete O'Hanlon2-Jul-18 3:04
protectorPete O'Hanlon2-Jul-18 3:04 
QuestionUser Defined Lookups Pin
Kevin Marois26-Jun-18 8:05
professionalKevin Marois26-Jun-18 8:05 
I want to allow the user to create their own lookup values that would be populated in a combo box. For example, an account's Statuses might be New, In Progress, or Closed. The use can Add, Edit, and Remove these from the lookup table at any time.

For this, I have a lookup table with Id, Caption, and Category. Other tables might have a StatusId that has an FK to Lookups.Id.

So, some questions:

1) Before they can remove a status I would like, to ensure that the Id isn't in use. I could query each table that it the target of the FK. Is there a simpler, more manageable way?

2) I would like to take action when the user selected the Closed option. How do I know for sure that this particular Lookup item was selected? Since it can be renamed I can't rely on the caption. I could have some other column in the table with some identifier in it and check that identifier in code, but that couples the code to a specific data item.

Thanks
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

AnswerRe: User Defined Lookups Pin
Mycroft Holmes26-Jun-18 14:51
memberMycroft Holmes26-Jun-18 14:51 
AnswerRe: User Defined Lookups Pin
Gerry Schmitz27-Jun-18 10:02
mveGerry Schmitz27-Jun-18 10:02 
GeneralRe: User Defined Lookups Pin
Kevin Marois27-Jun-18 10:05
professionalKevin Marois27-Jun-18 10:05 
GeneralRe: User Defined Lookups Pin
Gerry Schmitz27-Jun-18 10:28
mveGerry Schmitz27-Jun-18 10:28 
GeneralRe: User Defined Lookups Pin
Kevin Marois27-Jun-18 10:30
professionalKevin Marois27-Jun-18 10:30 
PraiseIdentifying Vulnerable Source Code Pin
David A. Gray5-Jun-18 11:28
groupDavid A. Gray5-Jun-18 11:28 
GeneralData Mapper Pattern Using Events Pin
Paramecium135-Jun-18 7:03
professionalParamecium135-Jun-18 7:03 
GeneralRe: Data Mapper Pattern Using Events Pin
Nathan Minier6-Jun-18 1:40
professionalNathan Minier6-Jun-18 1:40 
GeneralRe: Data Mapper Pattern Using Events Pin
Paramecium137-Jun-18 6:41
professionalParamecium137-Jun-18 6:41 
GeneralRe: Data Mapper Pattern Using Events Pin
Nathan Minier7-Jun-18 6:49
professionalNathan Minier7-Jun-18 6:49 
GeneralRe: Data Mapper Pattern Using Events Pin
Paramecium137-Jun-18 7:12
professionalParamecium137-Jun-18 7:12 
GeneralRe: Data Mapper Pattern Using Events Pin
Nathan Minier7-Jun-18 7:30
professionalNathan Minier7-Jun-18 7:30 
SuggestionRe: Data Mapper Pattern Using Events Pin
Eddy Vluggen6-Jun-18 1:50
mveEddy Vluggen6-Jun-18 1:50 
GeneralRe: Data Mapper Pattern Using Events Pin
Paramecium136-Jun-18 8:16
professionalParamecium136-Jun-18 8:16 
QuestionUnified Naming Conventions Pin
David A. Gray29-May-18 8:53
groupDavid A. Gray29-May-18 8:53 
AnswerRe: Unified Naming Conventions Pin
Eddy Vluggen31-May-18 0:17
mveEddy Vluggen31-May-18 0:17 
GeneralRe: Unified Naming Conventions Pin
David A. Gray31-May-18 14:14
groupDavid A. Gray31-May-18 14:14 

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.