Home » Developer & Programmer » Forms » Making one to many relation for the same table!!!
Making one to many relation for the same table!!! [message #209868] Mon, 18 December 2006 04:02 Go to next message
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
Re: Making one to many relation for the same table!!! [message #209979 is a reply to message #209868] Mon, 18 December 2006 18:03 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Yes, you can. relate them with check_no
Re: Making one to many relation for the same table!!! [message #209987 is a reply to message #209868] Mon, 18 December 2006 19:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous messageGo to next message
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     


Re: Making one to many relation for the same table!!! [message #210206 is a reply to message #210048] Tue, 19 December 2006 18:47 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why is this a problem? What do you want the application to do with these 'unfilled' records?

David
Re: Making one to many relation for the same table!!! [message #210261 is a reply to message #209868] Wed, 20 December 2006 01:24 Go to previous messageGo to next message
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
Re: Making one to many relation for the same table!!! [message #211734 is a reply to message #210261] Tue, 02 January 2007 00:34 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

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


Current Time: Wed Dec 07 20:21:40 CST 2016

Total time taken to generate the page: 0.12090 seconds