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 60,993 Super User 2025 Season 2 on at

Like (0)

Report

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 60,993 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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,885 on at

Like (0)

Report

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

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 60,993 Super User 2025 Season 2 on at

Like (0)

Report

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