have a problem i can't seem to solve.
want to limit/filter the records displayed in autolookup on a form
control.
i've been able to do this on other projects i worked on simply by
setting relations on and EDT and the tables involved, but that
doesn't seem to work for this case.

i have a table named LeaseItems that is related to SalesLine table.
on sales order form in detail section, i've added a control
named 'LeaseItemIid' and the datasource is LeaseItems.ItemGroupID.
The LeaseItems table also contains a field named ItemID that contains
inventory item id's.

the autolookup displays all records in LeaseItems table and I want to
limit/filter this to show only those items from LeaseItems table
where LeaseItems.ItemID == SalesLine.ItemID.

wondering if it's possible to use a find method to populate the
control with only the records I want or if i would have to use the
class SysTableLookup to override the lookup method on the form
control.



Yahoo! Groups Sponsor
ADVERTISEMENT
click here


Yahoo! Groups Links

Reply via email to