Home » Developer & Programmer » Forms » forms and joins
forms and joins [message #78353] Fri, 15 February 2002 12:16 Go to next message
Dave
Messages: 92
Registered: August 1999
Member
i have a form that has two tables cust and rental. the first table rental is linked to the second table cust by the cust no. how do i link the cust table to the rental table so that when the user enters search information into the custno field the correct data appears also appears in the rental table
Re: forms and joins [message #78356 is a reply to message #78353] Fri, 15 February 2002 18:51 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
hi,
try to create two blocks in the form, one form type and other tabular. create a relation between the two.
execute the query in the master block, automatically the rental block(detail block) values gets populated

ram
Previous Topic: LONG Insertation
Next Topic: troble in totaling
Goto Forum:
  


Current Time: Sun Mar 29 23:15:46 CDT 2020