Click here to Skip to main content
12,243,522 members (47,365 online)

Design and Architecture

 
GeneralRe: Estimate the cost of a Software application Pin
grmihel28-Mar-11 23:27
membergrmihel28-Mar-11 23:27 
AnswerRe: Estimate the cost of a Software application Pin
Piccadilly Yum Yum3-Mar-11 3:24
memberPiccadilly Yum Yum3-Mar-11 3:24 
QuestionUnified System Security Design - Database / Code / Both! Pin
Jammer13-Feb-11 8:51
memberJammer13-Feb-11 8:51 
AnswerRe: Unified System Security Design - Database / Code / Both! Pin
Manfred R. Bihy13-Feb-11 11:37
memberManfred R. Bihy13-Feb-11 11:37 
GeneralRe: Unified System Security Design - Database / Code / Both! Pin
Jammer15-Feb-11 5:04
memberJammer15-Feb-11 5:04 
QuestionIs MSMQ old school Pin
Robert Croll1-Feb-11 1:08
groupRobert Croll1-Feb-11 1:08 
AnswerRe: Is MSMQ old school Pin
Pete O'Hanlon1-Feb-11 1:14
mvpPete O'Hanlon1-Feb-11 1:14 
QuestionDatabase UI Design Pin
Leslie Sanford29-Jan-11 9:33
memberLeslie Sanford29-Jan-11 9:33 
I'll preface this by saying that I'm not exactly a DB programmer, though I've been doing more and more of it lately.

Say you have a typical database with Products, Customers, and Orders tables. The Orders table is an associative table with foreign keys to Products and Customers. Standard fare. You have a UI front end for the database with views for viewing many records and views for viewing/creating a single record.

A customer calls to place an order, so the operator fires up the Create Order form to enter the data. On the form are the controls for entering the data, like textboxes, checkboxes, etc. Once the order info has been entered, the operator hits the Submit button, and the order is added to the Orders table.

However, the Orders table is an associative table, so the info for entering the customer ID as well as the product ID needs to be correct, i.e. the values entered into those fields need to correspond to an existing customer and product respectively.

My question is what are some ways in which this can be implemented in the UI? One could use list boxes for the customer and product so that the operator can easily choose values from those tables to enter in to the order. However, this approach doesn't scale well. There could be thousands of products and customers to choose from. Putting them all into list boxes isn't really going to work. Maybe instead some type of table view that can popup to let the operator choose from it?

How is this usually handled in DB applications with a UI front end?
AnswerRe: Database UI Design Pin
Rags151230-Jan-11 6:47
memberRags151230-Jan-11 6:47 
AnswerRe: Database UI Design Pin
David Skelly31-Jan-11 3:39
memberDavid Skelly31-Jan-11 3:39 
AnswerRe: Database UI Design Pin
Robert Croll1-Feb-11 1:04
groupRobert Croll1-Feb-11 1:04 
AnswerRe: Database UI Design Pin
Eddy Vluggen4-Feb-11 12:21
memberEddy Vluggen4-Feb-11 12:21 
AnswerRe: Database UI Design Pin
nforlando2-Mar-11 4:26
membernforlando2-Mar-11 4:26 
AnswerRe: Database UI Design Pin
Piccadilly Yum Yum3-Mar-11 3:36
memberPiccadilly Yum Yum3-Mar-11 3:36 
QuestionPOP3 Components Pin
Jammer28-Jan-11 1:42
memberJammer28-Jan-11 1:42 
AnswerRe: POP3 Components Pin
phil.o28-Jan-11 3:38
memberphil.o28-Jan-11 3:38 
JokeRe: POP3 Components Pin
Jammer28-Jan-11 4:33
memberJammer28-Jan-11 4:33 
GeneralRe: POP3 Components Pin
phil.o28-Jan-11 5:06
memberphil.o28-Jan-11 5:06 
AnswerRe: POP3 Components Pin
Hans Dietrich4-Feb-11 13:00
mentorHans Dietrich4-Feb-11 13:00 
AnswerRe: POP3 Components Pin
Jammer14-Feb-11 0:56
memberJammer14-Feb-11 0:56 
GeneralRe: POP3 Components Pin
phil.o14-Feb-11 1:10
memberphil.o14-Feb-11 1:10 
QuestionOO design: Copying data from class A to B Pin
Nilzor26-Jan-11 0:05
memberNilzor26-Jan-11 0:05 
AnswerRe: OO design: Copying data from class A to B Pin
venomation26-Jan-11 2:03
membervenomation26-Jan-11 2:03 
GeneralRe: OO design: Copying data from class A to B Pin
Nilzor26-Jan-11 2:14
memberNilzor26-Jan-11 2:14 
GeneralRe: OO design: Copying data from class A to B Pin
Keld Ølykke26-Feb-11 15:12
memberKeld Ølykke26-Feb-11 15:12 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 29 Apr 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid