You are viewing limited content. For full access, please sign in.

Question

Question

Forms Lookup Question

asked on November 11, 2020

I have a Lookup setup that returns Purchase Order information (Line #s, descriptions, line total, etc.) The trigger for the lookup is the PO Number 

Our business process needs to segregate the returned PO values into two categories (Program Income & Non-Program Income). Is there anyway I can segregate the returned values inside of forms  Below is an example of what I am receiving and I also have highlighted the information I want segregated. In the example below Line(s) 1-5 need to be put into another section or even highlighted if possible. I am exploring with the end users a method to differentiate which POs have which highlighted but I need to know how to put it to work once I get there. I dont believe Forms allows any other factors in lookouts  such as (If PO equals this and description is TRANSPORT then do this) 

 

0 0

Replies

replied on November 11, 2020

Is the program income vs non-program income flagged in the database? You can have two inputs to the lookup. For a solution, you could create two tables

1. Program Income - lookup: If PO# matches PO# and Income type = Program, fill...

2. Non-Program Income - lookup: If PO# matches PO# and Income type = Non-program, fill...

Then you'll have two tables with the rows separated. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.