query [message #77762] |
Tue, 13 November 2001 12:19 |
Ken
Messages: 50 Registered: April 1998
|
Member |
|
|
I am having problems with the query button that forms automattically creates. Basically I want to enter in a user_id and a date (which are part of one block) and get all detail records that have the same user_id and date. I have set up the second block to be all the detail records with a master/detail relationship created. The relationship uses the user_id, while in the detail block properties under the where clause there is a link for the date. The user_id is the primary key for the master block and the foriegn key in the detail block. When I enter in my query and then try to execute it, it just wipes all the fields and puts me back to normal mode.
Any ideas or help would be appreciated.
Thanks
----------------------------------------------------------------------
|
|
|
Re: query [message #77764 is a reply to message #77762] |
Wed, 14 November 2001 03:49 |
Shilpa
Messages: 59 Registered: November 2001
|
Member |
|
|
Take out the master detail relationship and add the user_id in the where clause of the detail block along with the date and try executing the query.
----------------------------------------------------------------------
|
|
|