OraFAQ Forum: Forms » Making one to many relation for the same table!!!

Home » Developer & Programmer » Forms » Making one to many relation for the same table!!!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Making one to many relation for the same table!!! [message #209868]

Mon, 18 December 2006 04:02

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

hii all

i have a table that have those fields

check_no
bank
branch
value

i want to use this table as one to many relation
such that be displayed on two blocks

as the first block contain the "CHECK_NO"

and the next block contain "BANK" , "BRANCH", "VALUE"

can i do that

thanks for everyone helped and helping me

Report message to a moderator

Re: Making one to many relation for the same table!!! [message #209979 is a reply to message #209868]

Mon, 18 December 2006 18:03

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Yes, you can. relate them with check_no

Report message to a moderator

Re: Making one to many relation for the same table!!! [message #209987 is a reply to message #209868]

Mon, 18 December 2006 19:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You can also use a single block and specify that the 'check_no' occurs 10 times and the other fields only occur 1 time. This way you can have a list of 'check_no' but only the details of the highlighted 'check' will be displayed.

David

[Updated on: Mon, 18 December 2006 19:49]

Report message to a moderator

Re: Making one to many relation for the same table!!! [message #210048 is a reply to message #209868]

Tue, 19 December 2006 02:23

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

thanks for your replies
the main problem that will occur that some records will be complete and other will contain the check no only

as the complete record will look like

check_no  bank  branch  value
  1258      1     1      20

and the uncomplete record will look like

check_no  bank  branch  value
  1258

Report message to a moderator

Re: Making one to many relation for the same table!!! [message #210206 is a reply to message #210048]

Tue, 19 December 2006 18:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Why is this a problem? What do you want the application to do with these 'unfilled' records?

David

Report message to a moderator

Re: Making one to many relation for the same table!!! [message #210261 is a reply to message #209868]

Wed, 20 December 2006 01:24

emadbsb
Messages: 334
Registered: May 2005
Location: egypt

Senior Member

no on the contrary
i don't the record to be in that form

please help me

i want one to many block for the same table
but in the same time i doesnot leave a part of the record with nulls

Report message to a moderator

Re: Making one to many relation for the same table!!! [message #211734 is a reply to message #210261]

Tue, 02 January 2007 00:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	ERROR: ORA-06502
Next Topic:	Only with Runtime component.(10g)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:31:34 CDT 2024