Database

coolestCoder5-Dec-07 4:13

coolestCoder

5-Dec-07 4:13

You will have a master table as you have shown already and details table referencing invoice number (primary key) of the master table. Then you can add as many records against your primary as you want.

Your query will include an inner join with condition -- MasterTable.InvoiceNo = DetailsTable.InvoiceNo

Hope that answers your question.
You must be able to complete rest of the work.

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

database design

avvaru.murali5-Dec-07 1:22

5-Dec-07 1:22

Hi,
my database is Ms-Access database..
iam doing product based application(windows application)

i have to store data based on the invoice number...
invoice number is (primarykey)
based on invoice number i have to store multiple items

reports

when i select invoice number those items should be displayed...

please help me

murali krishna

Ujjaval Modi5-Dec-07 1:29

Ujjaval Modi

5-Dec-07 1:29

Hi,

Just write the query with where condition.
for eg.
select * from tablename where invoicenumber='xyz'

Regards,
Ujjaval Modi

avvaru.murali5-Dec-07 1:32

5-Dec-07 1:32

Hi
Thanks for your reply...

my problem is
my database is (ms-access) database

ihave to store multiple items in one invoice number(primary)

invoiceNo items units
1 Nokia6600 4
Nokia6633 5
Nokia6030 3

2 Nokia 1300 2
Nokia 1100 3

like this ....(database design) and coding in c# application

murali krishna

Ujjaval Modi5-Dec-07 1:39

Ujjaval Modi

5-Dec-07 1:39

What exactly do u want ?

A database design or u already have one ?

Regards,
Ujjaval Modi

avvaru.murali5-Dec-07 1:42

5-Dec-07 1:42

Hi,
yes i want database design

murali krishna

Ujjaval Modi5-Dec-07 1:44

Ujjaval Modi

5-Dec-07 1:44

Just mention clearly that u want a working sample.

Regards,
Ujjaval Modi

avvaru.murali5-Dec-07 1:48

Re: database design [modified]

5-Dec-07 1:48

Hi,
ya if it is ok ----
clearly i want database design and query for inserting and selecting
that that particular table

i have to desing table like this

invoiceNo(primarykey),products,units,Cost

in this one invoice number should consists od mmultiple products information....
this is main i Want ..

murali krishna

Eric.W28-Dec-07 15:45

Eric.W

28-Dec-07 15:45

i think your datatable should designed as follows:

ProductedId(pk) Products units TypeId
1 Nokia1600 2 1
2 Nokia1700 5 1
3 Nokia1800 6 1
4 Nokia2600 2 2
5 Nokia4600 8 2
6 Nokia8100 2 3
7 Nokia8300 1 3
8 Nokia56 6 3
9 Nokia1310 2 3

Connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

query sentence:

select * from products where typeid=x;

hope it will work as you wanted.

modified on Saturday, December 29, 2007 11:57:04 PM

Why sql query is not running...? in MSACCESS 2000

Pankaj - Joshi5-Dec-07 0:02

Pankaj - Joshi

5-Dec-07 0:02

I want to trim the value so i just write a simple query
in MSACCESS 2000

SELECT Trim([ItemName]) AS Expr1
FROM Items

But it will give error "Undefind function "Trim" in expression"

What to do...?

Regards
Pankaj Joshi

If you want to shape your dreams into reality, please wake-up...

Re: Why sql query is not running...? in MSACCESS 2000

GuyThiebaut5-Dec-07 0:57

GuyThiebaut

5-Dec-07 0:57

There is no TRIM commmand in T-SQL you have to use LTRIM then RTRIM as follows:

SELECT LTRIM(RTRIM(ItemName)) Expr1 FROM Items

Regards

Guy

You always pass failure on the way to success.

Re: Why sql query is not running...? in MSACCESS 2000

Pankaj - Joshi5-Dec-07 1:12

Pankaj - Joshi

5-Dec-07 1:12

Thanks for reply but still query is not working

Same error occurred for LTRIM function

SELECT LTRIM(RTRIM(ItemFullName)) as Expr1 FROM Items Confused | :confused:

Regards
Pankaj Joshi

If you want to shape your dreams into reality, please wake-up...

Re: Why sql query is not running...? in MSACCESS 2000

Support1235-Dec-07 1:28

Support123

5-Dec-07 1:28

could it be that he is missing references Confused | :confused:

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Re: Why sql query is not running...? in MSACCESS 2000

Pankaj - Joshi5-Dec-07 16:44

Pankaj - Joshi

5-Dec-07 16:44

How to add the reference...?

If I write LTRIM RTRIM in a query using C#.net and deploy the application to client site then same problem may occurred...?

Regards
Pankaj Joshi

If you want to shape your dreams into reality, please wake-up...

How to find the sql servers on network [modified]

aswini4-Dec-07 20:41

aswini

4-Dec-07 20:41

Hi.. All...

I am working on a database project..

I have to find all the sql servers running on network.

i am searching in google,
unfortunately i am not getting the logic or code about how to proceed ..

Thanks in ADVANCE..

Aswini

modified on Wednesday, December 05, 2007 7:36:03 AM

Rajesh R Subramanian4-Dec-07 20:48

Rajesh R Subramanian

4-Dec-07 20:48

We need the big red NO PROGRAMMING QUESTIONS IN THE LOUNGE banner back in place!

Nobody can give you wiser advice than yourself. - Cicero
.·´¯`·->ßRÅhmmÃ<-·´¯`·.

Vasudevan Deepak Kumar4-Dec-07 21:25

4-Dec-07 21:25

This is misleading:

Got a Programming Question? Click here!

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Mustafa Ismail Mustafa4-Dec-07 21:27

Mustafa Ismail Mustafa

4-Dec-07 21:27

I agree, but you would expect someone with some web page reading skills would recognize that this is linked.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

"There is no wealth like knowledge, no poverty like ignorance." Ali ibn Abi Talib

"Animadvertistine, ubicumque stes, fumum recta in faciem ferri?"

Vasudevan Deepak Kumar4-Dec-07 21:33

4-Dec-07 21:33

Mustafa Ismail Mustafa wrote:
but you would expect someone with some web page reading skills would recognize that this is linked.

Even with big colored banners, we encounter real dumb persons dumping sh*t all around. How do you expect a little text without any adoration to help out a color-blind myopic persons?

This is where 'Web Page Accessibility Guidelines' comes into play. Isn't it? Big Grin | :-D

Mustafa Ismail Mustafa4-Dec-07 21:39

Mustafa Ismail Mustafa

4-Dec-07 21:39

Vasudevan Deepak K wrote:
Even with big colored banners, we encounter real dumb persons dumping sh*t all around.

That sounds like the banners that they set up here at the voting centers.

Vasudevan Deepak K wrote:
How do you expect a little text without any adoration to help out a color-blind myopic persons?

Uh.. Super-webpage man comes to the rescue?

Vasudevan Deepak K wrote:
This is where 'Web Page Accessibility Guidelines' comes into play. Isn't it?

That and a dash, just a sprinkling mind you, of common sense. Alas, there's a worldwide shortage!!

Malcolm Smart4-Dec-07 21:33

Malcolm Smart

4-Dec-07 21:33

Didn't it say 'Post Here' before - which was misleading. Click here is now obvious I'd have thought.

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

Vasudevan Deepak Kumar4-Dec-07 21:35

4-Dec-07 21:35

/* Just posted this part of another thread on this topic */

Even with big colored banners, we encounter real dumb persons dumping sh*t all around. How do you expect a little text without any adoration to help out a color-blind myopic persons?

Pawel Krakowiak4-Dec-07 21:41

Pawel Krakowiak

4-Dec-07 21:41

How about a checkbox under the Text field which says '[x] This is not a programming question' (unchecked by default). Then after you check it and click Post Message a JavaScript dialog pops up and asks 'Are you sure this is not a programming question? [Yes/No]'.

This would be annoying for everyone, but it still might work. Poke tongue | ;-P

Although knowing trolls it probably wouldn't.

Kind regards,
Pawel Krakowiak

Miraculum Software[^]

Vasudevan Deepak Kumar4-Dec-07 21:46