2. ASPRunnerPro General questions
  3. Newbie Filter-Question
This topic is locked

Newbie Filter-Question

 		12/13/2005 10:23:37 AM
ASPRunnerPro General questions
C
 chip99 author

Hi

I'm not very experienced in asp.net and also not in your product. I'm sure you can help me. I've 2 questions about your product:

  1. Question: How to set directly a filter?

    I've a customer table with a number and an other table with Total Records and Detail Records. I need now a predefined filter for my customer to show him only "his" records. Key is here a department-number and a date of the generated job. Both fields are unique together.
  2. Question: how can I connect the master with the detail-Table?

    I've the Total-Table witch has 2 Total-Records. Each of these Total-Records contains many Detail-Records (I want them to shown as a table but only those witch are resulting in this total-record. Here I've the same fields in the tables (department-number and also the date).
    Thanks very much for your assistance.

    Greetings

    Chip99 <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2193&image=1&table=forumtopics' class='bbc_emoticon' alt=';)' />
Sergey Kornilov admin 12/15/2005

Hi,
please see my answers.

  1. You can use Advanced security mode "Users can see and edit their data only". You can enable it in Advanceddialog on Securitytab in ASPRunner.
  2. You can set master-detail relationship on DataSource table tab in ASPRunner. However only one field can be used as a link between master and detail tables.