Adding fields from Another Table

(0) Share

Report

Posted on by Community Member

Hello, On the item Bin Contents I've created two new fields, Sell-to Customer Name and Item Description. I'm trying to retreive these from the Item Card.

My assumption was

recItem.GET(recItem."No.");
"Sell-to Customer Name" := recItem."Sell-to Customer Name";

Would work but it doesn't? What should I change

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Mohana Yadav 61,186 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

do you have Sell-to Customer Name field in Item table?

recItem.GET(<use item field from Bin Content record>);

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,186 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

you can also create flow fields in Bin Contents table

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

As Mohana suggested you need to have those field on the source table from there you can show the values on target table

Check the fields and relationship between two tables.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Thank you, I've attempted to create a flowfield

However now when I go into the Item Bin Contents Page I get this error

Was this reply helpful? Yes No
Suggested answer

Binesh 7,887 on at

Like (0)

Report
Copy link

Link copied!

You have to write something like:

IF recItem.GET("Item No.") THEN BEGIN

"Item Description" := recItem.Description;

"Sell-to Customer Name" := recItem."Sell-to Customer Name";

END;

Note: Here "Item No" is a Bin Contents Filed

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you again. I Have the Sell to Customer No and item Description populating However I realise I need to get the Sell-to Customer Name from the Customer table. I Attempted to create a flowfield for this

Lookup(Customer.Name WHERE (Name=FIELD(Sell-to Customer Name)))

And wrote

IF recCustomer.GET("Item No.") THEN BEGIN

"Sell-to Customer Name" := recCustomer.Name;

END;

But It errors and the page doesn't load, what should I alter?

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,186 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You need to read some help regarding using GET function.

how to you get customer record with Item No?

recCustomer.GET("Item No.")

Was this reply helpful? Yes No