Re: Limit number of records in a prompt table

Re: Limit number of records in a prompt table

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by [IP Address: 205.174.143.2] 'Todd' on August 30, 2001 at 12:44:48 EST:

In Reply to: Re: Limit number of records in a prompt table posted by [IP Address: 205.174.143.2] 'ShuSheng Li' on August 30, 2001 at 12:16:52 EST:

Ok, the Business Unit is associated with the employee on the panel. You would like to limit the rows returned by a view. This view has Business Unit as a field. You want only the rows belonging to the employee business unit and the vies business unit. If this is correct, all you have to do is add code to the field default of the view...hence view.bus_unit -> fieldDefault. (view.bus_unit = employeerecord.bus_unit;)

this should limit the view the way I have described...and the way I understand that you are using the view. Hope this helps

Follow Ups:

Re: Limit number of records in a prompt table ShuSheng Li 13:18:22 8/30/01 EST (0)

Post a Followup

Name:
E-Mail:
Subject:
Message: : Ok, the Business Unit is associated with the employee on the panel. You would like to limit the rows returned by a view. This view has Business Unit as a field. You want only the rows belonging to the employee business unit and the vies business unit. If this is correct, all you have to do is add code to the field default of the view...hence view.bus_unit -> fieldDefault. (view.bus_unit = employeerecord.bus_unit;) : this should limit the view the way I have described...and the way I understand that you are using the view. Hope this helps