Click here to Skip to main content

Design and Architecture

GeneralRe: Estimate the cost of a Software application Pinmembergrmihel28-Mar-11 22:27 
AnswerRe: Estimate the cost of a Software application PinmemberPiccadilly Yum Yum3-Mar-11 2:24 
QuestionUnified System Security Design - Database / Code / Both! PinmemberJammer13-Feb-11 7:51 
AnswerRe: Unified System Security Design - Database / Code / Both! PinmemberManfred R. Bihy13-Feb-11 10:37 
GeneralRe: Unified System Security Design - Database / Code / Both! PinmemberJammer15-Feb-11 4:04 
QuestionIs MSMQ old school PingroupRobert Croll1-Feb-11 0:08 
AnswerRe: Is MSMQ old school PinmvpPete O'Hanlon1-Feb-11 0:14 
QuestionDatabase UI Design PinmemberLeslie Sanford29-Jan-11 8: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 PinmemberRags151230-Jan-11 5:47 
AnswerRe: Database UI Design PinmemberDavid Skelly31-Jan-11 2:39 
AnswerRe: Database UI Design PingroupRobert Croll1-Feb-11 0:04 
AnswerRe: Database UI Design PinmemberEddy Vluggen4-Feb-11 11:21 
AnswerRe: Database UI Design Pinmembernforlando2-Mar-11 3:26 
AnswerRe: Database UI Design PinmemberPiccadilly Yum Yum3-Mar-11 2:36 
QuestionPOP3 Components PinmemberJammer28-Jan-11 0:42 
AnswerRe: POP3 Components Pinmemberphil.o28-Jan-11 2:38 
JokeRe: POP3 Components PinmemberJammer28-Jan-11 3:33 
GeneralRe: POP3 Components Pinmemberphil.o28-Jan-11 4:06 
AnswerRe: POP3 Components PinmentorHans Dietrich4-Feb-11 12:00 
AnswerRe: POP3 Components PinmemberJammer13-Feb-11 23:56 
GeneralRe: POP3 Components Pinmemberphil.o14-Feb-11 0:10 
QuestionOO design: Copying data from class A to B PinmemberNilzor25-Jan-11 23:05 
AnswerRe: OO design: Copying data from class A to B Pinmembervenomation26-Jan-11 1:03 
GeneralRe: OO design: Copying data from class A to B PinmemberNilzor26-Jan-11 1:14 
GeneralRe: OO design: Copying data from class A to B PinmemberKeld Ølykke26-Feb-11 14:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.141022.1 | Last Updated 21 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid