| forms and joins [message #78353] |
Fri, 15 February 2002 12:16  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
