DB/Reporting :: Relation DB Design?

Apr 21, 2010

I am designing a system for our sales team to enter their sales expenses. I have designed an input form and need some advise on what exactly I should store in the expenses table VS lookup from the employee table.

First, the form has a text box where the user must enter their EmployeeID. Management asked for a text box VS a combo box because they do not want users looking at each others expenses. The form has a search feature where by after you enter your employee number, it will look for an existing expense ticket first before allowing you to create a new one. Anyway, here are some of the decisions I have to make.

When the user enters their employee number, I would like to display their employee name. The EmployeeID is saved in the Expense table but should I also store the name in the expsense table? If I do save it, it's duplication of data, if I do not, I have to look it up each time the record is loaded. But is there a point storing the name long term? Does this qualify as related data? If I was to perform some reporting, could this cause a problem if an employee changes their name etc.

The expense data is spread over 2 tables, the first for the header details including employeeID, expense date and Expense ID etc. The second table contains the expense lines information. Amount, customer, category etc. My next question is when the employee chooses an expense category, there is an associated general Ledger code with that category. Again, the expense category data is stored in a table. When the user chooses the expense category, should I store the categoryID or store the values associated with the ID (GLAcct, CategoryDescription etc.) Does this qualify as related data or should lookup values always be duplicated in the master table? It is possible that over time, the GL accounts associated with the Expense categories could change. So for accuracy purposes, should they be stored in the expense lines table?

View 2 Replies


ADVERTISEMENT

IDE :: Design A ContextMenuStrip In A Designer Without A Relation To A Specific Form Or UserControl Class?

Oct 16, 2011

in VS 2008, is there a way to design a ContextMenuStrip in a designer without a relation to a specific Form or UserControl class? For example,if you need the same ContextMenuStrip in Form1, Form2 and Form3, in which of them am I to design the ContextMenuStrip? Do I have to add a "pseudo-Form" to the project that contains my shared ContextMenuStrips and create only one instance of that Form, or is there another way? I consider this a programmatic hack, that's why my question is whether the IDE offers something better.

View 10 Replies

DB/Reporting :: Relation Between Two Similar Data In Two Tables?

Oct 9, 2008

I want to make relationship between them Where In the F column of Table2 will sum the numbers in F column of table 3 according this condition ( show in the pic.)For the same data in columns(B,C,D) between two tables Example: Table 2 include in B,C,D data HH XX FF There are many data (HH XX FF) in tables3 in same columns(b,c,d) so it will sum the numbers in F column that in the same row with the data (HH xx FF), and insertded the results in the in table2 in F colmn in the same row with (HH XX FF)

View 10 Replies

DB/Reporting - Simple DB Steps - Building Two Forms With One To Many Relation

Aug 4, 2009

With a 1-many relation. Ok, I have constructed the schema, and now I want to make the appropriate forms in which a user would scroll for a customer and then by pressing a button, a new form would appear showing all the orders that he has made.

I am interested in the way of building two forms that would have a one to many relation. That is basically what I would like to know. Also, Do you have any good book to suggest in order to create a real world app, in VB2008, Emphasizing in data-binding and connecting controls with underlying DB, one to many forms, searching etc.

View 6 Replies

DB/Reporting :: Created Columns For The Datagridview At Design Time

Mar 5, 2009

Am using VB.net 2005, and I've created columns for the datagridview at design time. But when I run the code the fill method of the DataAdapter, the columns I created are not filled with data, but automatically generated columns appear. How can the columns I created at design time be filled with data?

View 1 Replies

DB/Reporting :: Making Design Changes To Table In Live Environment

Apr 12, 2012

In a program I am creating, i want to let the user add and remove fields on an entity, lets say "people". So I have a table named "People", with ID and Name columns. Now, I want to let the user choose "add field" in a webpage, define for instance "email" field, and then use "ALTER TABLE" from the codebehind to create the new field in the table. What I want to know is: is this recommended? It seems like a simple way to do this, but since I have never seen any other programs doing it like this (Using ALTER TABLE statements from codebehind in a live environment) - and since it changes the design of the DB -

View 3 Replies

DB/Reporting :: .Net/Oracle Application Best Design When Building Sql Command Parameters

Oct 2, 2009

Currently working on a web-service with Oracle10g as back-end. Here is my problem.

1. The table I need to populate has 100 columns. I have no control over the design of the table.

2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.

I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows

-intranet
-around 2000 users
-users spread out in different parts of the country

I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.

I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.

View 3 Replies

DB/Reporting :: Database Design Quandary Modelling 'substitutions' Or 'equivalency' Of Records

Jan 14, 2009

I've got a large and complex database system that is about to get even more complex, and I'm having trouble coming up with a reasonable way to model the new requirements so as to minimize the performance hit.For simplicity's sake, I'm going to use the example of certification exams, although it's not a perfect analogy for my system. So we have the following tables:

- Person
- Certification
- Exam
- Certification_Exams (join table indicating which exams are required per cert)
- Person_Exams (join table indicating which exams a person has taken)

Given that model, we can easily show that Certification A requires Exam 1, and Certification B requires Exam 2 and Exam 3.We can also determine whether a person is certified by checking Person_Exams to see if they have passed all exams required for the certification we're querying. (Note that we are not directly storing certifications for a person; these must be derived. That's one of the areas where the cert exam analogy doesn't quite match my real-life scenario, so please accept that there's a good business reason for it.In my world, the cert requirements are going to change frequently, so a person might get suddenly "un-certified.")Now enter the new requirement: We now need to be able to indicate that Certification A could be satisfied by either Exam 1 or Exam 4.And furthermore, Certification B always requires Exam 2 but also requires either Exam 3 or the combination of Exams 5, 6, and 7.I've come up with a couple different approaches so far, but the subsequent queries to be able to tell whether someone meets the criteria for a given certification are then incredibly complex.

View 11 Replies

Css - Design A Webpage In Asp.net Design View Which Support Multi Resolution?

Nov 26, 2010

I have created my webpage in asp.net in 1024*768 resolution, my problem was that when i change my monitor resolution then the controls in my webpage will be displayed in unmanaged manner .

How to arrange items in my webpage which support multiple resolution ...

Whatever the resolution of my monitor the controls in my webpage will display as it is as managed in 1024*768 reolution !

View 1 Replies

Form Design - Cannot Expand Vertically In Design View

Jun 27, 2011

I seem to have reached a limit on the size of the form. I cannot make the form longer and I need to add more fields. Is there a limit on how many fields can be included in a form?

View 1 Replies

Get Relation Between 2 Databases?

Jun 7, 2011

I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file (two different tables SQLtableOrders & SQLtableCustomerA))

datasetOrders.Tables("Orders") >>> the first column "orderID" is a primary unique key. Its structure is details below :
OrderID----OrderName----OrderCost--------Date
1----------A---------------54------------11/11/2010

[Code].....

note that I had already made this by getting the data by SQL Statement "Select SQLtableOrders.* , SQLtableCustomerA.orderID FROM SQLtableOrders, SQLtableCustomerA WHERE SQLtableOrders.orderID = SQLtableCustomerA.orderID" It is really working fine , but the problem that it takes time to get data from the SQL server each time I disply orders. I already have the datasetOrders.Tables("Orders") data on the client PC , I need only to make the client PC extract which orders are assinged to a ceratin customers. I can do it by For... Next , but I guess it will take time , specially if "orders" data contains many data .

View 8 Replies

.net - EF - Only Removes Relation When Hit By Breakpoint?

Jun 7, 2012

<HttpPost()>
Function Edit(<Bind(Prefix:="Article")> ByVal Article As FormCollection, Optional ByVal DepartementID As Integer = 0, Optional ByVal LeverancierID As Integer = 0) As ActionResult ', ByVal ReferenceSupplierID As Integer
' Dim Art As Article = ArticleService.GetArticleById(Article.ArticleID)
Dim _toUpdateArt As Article = ArticleService.GetArticleById(Article(0))
UpdateModel(_toUpdateArt, Article)

[Code]...

toUpdateArt.Departement = Nothing and _toUpdateArt.Supplier = Nothing is to remove the optional relationship.But it only works when i debug it and sometimes after several loops of the command, before the relation is actually removed and it's stored in the database.When there isn't a breakpoint on the "function", the Relationship will never be nulled.Does anyone has an explanation for this and how to fix this?

View 1 Replies

Add A Many-To-Many Relation In Entity Framework?

Apr 17, 2009

I am a newbie. I have been able to Add new entities where there is a One-To-Many Relation. I am having a problem (don't Know how to do it) adding a new Entity when the relation is using Many-To-Many. In my EDM I have:

[Code]....

View 1 Replies

Information With Relation To A Combo Box?

May 5, 2010

I want to have a combo box with a list of names. When one of the names is selected, I want the phone number and email to be displayed below it in a text box (or something similar).

View 6 Replies

VS 2008 Relation Between Two Tables?

Apr 14, 2009

i have two tables ( employees and departments )i want to insert data in employees table via employees form .so how can i put the departments names in a combobox and when the user choose a specific one it will return a department number so i can pass it to the INSERT statement? i mean what is the exact SELECT statement to load the the information to the datatable do i need two SELECT statements or innerjoin or something else?

View 2 Replies

VS 2010 Data Relation In ADO.Net?

Aug 12, 2011

I have two tables populated in a dataset using sql data adapter.. i created relation by specifying two columns in each table.. added it in dataset and made datagridview to show related records.. but it shows only first record...

---code

Dim cons As New String("Data Source=xxxxSQLEXPRESS;Initial Catalog=emp;Integrated Security=True")
Dim sql1 As New String("Select * from tab1")
Dim sql2 As New String("Select * from tab2")

use uniscribe in visual basic?

View 4 Replies

What's The Relation Between Classes And Objects

Oct 14, 2009

relation between Classes and Objects with an example.Md. Marufuzzaman

View 7 Replies

C# - Design Reference And Object Oriented Design Of A CRM

May 25, 2011

I searched codeplex and google. I have found so many such as tustena but unfortunately they are not domain driven based and in these solutions I could not find a good modelling documents or references. i am a newbie in CRM but I am sensetive to design it with solid object-oriented fundamentals. Any reference or open source solution especifically for CRM design and implementaion in .NET? Cheers

View 1 Replies

Get The Angle Of A Line In Relation To The X Axis?

Apr 18, 2011

i am trying to get the angle of a line in relation to the x axis. The line is being drawn in a picturebox. So its the Upper right quadrant of the cartesian plane ... but its flipped over the x axis.im using this code

a=pt(1).x
b=pt(1).y
c=pt(2).x
d=pt(2).y

z=math.atan2((c-a),(d-b))*(180/math.pi)

The issue is that the line im drawing is almost parallel to the x axis but its returning a value of roughly 90 degrees .It seems like it is giving me the angle in relation to the y axis, but not being super good at the math myself im not exactly sure what to change here.

View 6 Replies

Combo Box Drop Down Value Relation Between Two Tabs?

Feb 8, 2011

i have a login form that contains a combo box and a text box and a button. the items of the como box are from the databse while the person selected can only log into the system if the password he enters on the textbox matches the password details in the database.(of the name selected)

my problem is, the second tab contains a couple of textboxes and combo boxes that need to be filled in. but i want the first combo box in the second tab to have drop down value of the name of the person that has logged in to fill in the form.

the person login in the first tab, his name should appera on the combo box in the second tab

View 3 Replies

Get A ContextMenuStrip In Relation To The Parent Control It's Under?

Dec 30, 2009

I've made a ContextMenuStrip to use in my program to change the image in a picture box. However, it's used with multiple picture boxes which each need to have their own changed. What I want to do is make my command change only that picture box leaving the others as they were before. An example, if this were a plausible code.

Private Sub TestToolStripMenuItem_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles TestToolStripMenuItem.Click
Self(aka the control that currently has the menu open).Image = My.Resources.Picture
End Sub

View 2 Replies

Get The Form Position In Relation To The Screen?

Apr 16, 2011

I have this code working fine , it takes pictures of the correct size and correct file name , however , all the pictures it takes are in the top left corner of the screen , rather than where i have the form to. FYI the picture box in the middle has no picture in it , and is transparent , i want to save a bitmap of the contents of the picturebox ( a user defined size of the screen). The picture box and button are docked so that the form scales properly when being resized.

[Code]....

View 4 Replies

Mouse Position In Relation To Picturebox

Oct 3, 2009

If I do the mousedown event in my picturebox, is there a way to calculate the mouse position in relation to the picturebox itself, or will I have to calculate it from the X/Y of the mouse and the X/Y of the picturebox? I can do the latter, just wondering if there's a command for the former.

View 2 Replies

Relation Between Two Combo Boxes In VB 2005

Apr 11, 2009

i am new to vb2005 and i am developing a project of a restaurant in vb2005. i have two combo boxes of PRICE and SOFTDRINKS. there are 5 different soft drinks and there are five different prices of the softdrinks in the combo box of PRICE. my requirement is that when i select the soft drink in the combo box of SOFTDRINKS then automatically the price relevant to that soft drink should be selected in the combo box of PRICE.

[Code]...

View 5 Replies

Relation For Multiple Columns Between Two Tables?

Jan 8, 2010

<vb.net 2008>
Table : MST_COMPANY / EMP_MASTER
Column : COMPANY_ID / LOCATION_ID

How do I add relations for two colums between two tables? I tried below way but it does not work.
Is there any other way?

Dim relCompanyEmp1 As DataRelation = ds.Relations.Add("relSectionEmp", ds.Tables("MST_COMPANY").Columns("COMPANY_ID"), ds.Tables("EMP_MASTER").Columns("COMPANY_ID"))
Dim relCompanyEmp2 As DataRelation = ds.Relations.Add("relSectionEmp", ds.Tables("MST_COMPANY").Columns("LOCATION_ID"), ds.Tables("EMP_MASTER").Columns("LOCATION_ID"))

[Code]...

View 5 Replies

.net - Querying Twice-separated-or-more Objects In A Relation Chain?

Apr 20, 2010

Not sure if I am using the correct term, but it's not child/parent since they aren't nested objects. In my application I've got a User, UserUserGroup, and UserGroup objects which are pretty standard, UserUserGroup is a linking object with corresponding IDs. I am using Linq-to-SQL so unforunately it doesn't used nested objects, but it still knows the relation.

[Code]...

View 1 Replies

C# - Relation Table In DataSet Always Returns 0 Rows

Jul 19, 2010

I have created a strongly typed dataset in the VS 2005 Dataset Designer. There are two tables that relates to each other in a one to many relationship: Claim and ClaimDetail. The designer automatically creates a function GetClaimDetailRows which returns all ClaimDetailRows for a ClaimRow. Why is this Array's length always 0? Because ClaimDetail contains more than 40 Million rows, i did'nt fill it before i call GetClaimDetailRows but had configured it's selectcommand that it takes a parameter idData to fill only the related records. But that seems not to work because the ClaimDetail-Datatable is empty.

The automatically generated function in the ClaimRow-Class which returns all related ClaimDetailRows:
Public Function GetClaimDetailRows() As ClaimDetailRow()
If (Me.Table.ChildRelations("Claim_ClaimDetail") Is Nothing) Then
Return New ClaimDetailRow(-1) {}
Else
Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("Claim_ClaimDetail")),ClaimDetailRow())
End If
End Function

When debugging I see that it jumps into the else block but returns 0 rows. Do I have to fill the Claimdetail-Datatable first(ClearBeforeFill=True) for each Claim? But then I don't need to use this function anymore. I now fill the Datatable(ClearBeforeFill=True)before i call the Child-function and it works. But I don't understand why it could not throw an exception(optionally) when I try to acess a child-relation without having that datatable being filled(at least with 0 rows). Instead of that it returns 0 rows what can be correct or incorrect and is difficult to detect.

View 1 Replies

Color.ToArgb Relation Between 5046311 And 14221235?

Sep 2, 2010

the form backcolor is 14221235 , but when i set the customcolor in colordialog to equal the form backcolor, it sets it to 5046311 !!! what is the problem?the reason i am turning it into a string is because i will feed it into a string which has "32498239, 234234234, 23423234, 32234432432, 423324234"then i take this string and put it in customcolors like this. btw this piece of code works fine:

Dim numberStrings = My.Settings.mytext1.Split(","c).Select(Function(x) x.Trim())
ColorDialog1.CustomColors = numberStrings.Select(Function(x) CInt(x)).ToArray()

View 6 Replies

VS 2008 Update Parent & Child With Relation

Aug 7, 2011

I am going to ask a dumb question. I want to update my tables (two). There is a one to many relation between them. I know how to update when only one table is update, but how do i update when there is many on the other side. My problem is that , if one of the records on the many should become redundant, how would i delete it in the update process. If only the content changes , it is not a problem, i know the data just gets written back to the tables, but if one of the child records is not delete, how would it work I need some clue on the SQL statement using OLEDB

View 2 Replies

VS 2010 Printer Co-ordinates In Relation To Margins

May 22, 2012

If I use the following code to draw a rectange, do the values inserted into 'fromleft' & 'fromtop' set a co-ordinate from the top/left corner of the paper or from the top/left corner of the margins.

Dim R As Rectangle
Dim across As Integer = 5
Dim down As Integer = 13

[Code]....

The reason I am asking this question is because I am trying to print labels so the position of the labels on the sheet are fixed. When the printer is set to papersize = letter the first label is in the correct position but when I change it to A4 the first label has moved 4mm to the right. With the margins set to 0 I still cant get it justified correctly. The printer is obviosly capable of printing 4mm from the left because it does so when set to 'letter'. Can't use letter because I need the extra length of A4 for the bottom row of labels.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved