Jump to content

Conditional Lookup


This topic is 5665 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi, I have a requirement to lookup data in my line items file differentiated by the client name.

The structure is as follows;

Client table related to Invoicing table by Client ID

Invoicing table related to Line Items Table by Invoice Number

Line Items Table related to Items Table by Item Number

One of the clients items price is different so I defined the price field in line items as:

Case(Company="CHECKERS";Lookup(Items::Price);Lookup(Items::Price1)

and that did not work so I tried changing the field to

If(Company="CHECKERS";Lookup(Items::Price);Lookup(Items::Price1) and that doesn't work either.

can anyone help please

Link to comment
Share on other sites

Tried that and that does not work either, the line items table only brings in one price no matter who the customer is. Is it possible that there is a problem with the relationship between the tables

Edited by Guest
Link to comment
Share on other sites

I can't tell from your description if this is an implementation problem, or if you are facing the problem described here. It actually doesn't matter much, because you will face that problem anyway. I still don't know a good solution to that one.

Perhaps making the user select the customer by a script (which would conclude by committing the invoice) would be a decent workaround.

Link to comment
Share on other sites

This topic is 5665 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.