Adding fields from Another Table

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (7)

Answers (0)

Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Adding fields from Another Table

You need to read some help regarding using GET function.

how to you get customer record with Item No?

recCustomer.GET("Item No.")
Community Member Microsoft Employee on at

Like (0)

Report

RE: Adding fields from Another Table

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?
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Adding fields from Another Table

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Adding fields from Another Table

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
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Adding fields from Another Table

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.
Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Adding fields from Another Table

you can also create flow fields in Bin Contents table
Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Adding fields from Another Table

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

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