Sign in to follow this  
Followers 0
madman411

list related records with certain value

4 posts in this topic

Hi all

I'm trying to create a calculation (order::list) to list related records that have the value of "1" in a field in the related table. My tables are "order" and "order lines". 

I use a portal for "order lines" on my Order layout. Right now they're connected by Order::OrderID and OrderLines::OrderID. Two fields in order lines table are OrderLines::Description and OrderLines::Flag. If the flag field is "1" I need the list field to list what's in the description field with a carriage return for all related records where the flag field is 1. If it's 0 or empty then that record needs to be ignored.

The List function works fine to return the contents of the Description field of all related records, but I'm struggling to make the calculation only look for certain values. I'm sure this is pretty simple but help would be much appreciated.

Thanks!

Share this post


Link to post
Share on other sites

Why do you need this?

The simple way, I think, would be to use another relationship - or perhaps a filtered portal.

Share this post


Link to post
Share on other sites
1 hour ago, comment said:

Why do you need this?

The system is connected to QuickBooks. The system subtotals on certain rows so when my boss pushes his orders to QB to create an invoice he only wants the information on these rows passed through.

Share this post


Link to post
Share on other sites
7 hours ago, madman411 said:

The system is connected to QuickBooks. The system subtotals on certain rows

That doesn't tell me anything.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0