I Have a Table Called "Manufacturer " With two Fields, "Code" and "Name".
Within the Job Queue Management I want to essentially create a record for each Customer. The Code would be the Customer "No." and the name would be the Name of the Customer's "Name".
Customer No. = Code
Customers name = Name
How would this be written? Thanks
Variables*
recCustomer
recManufactuer
*This post is locked for comments
Hello,
Follow the polo solution, you can also use my solution, this has little bit fast.
RCustomer -> Record -> Customer
RManufacturer-> Record -> Manufacturer
RCustomer.RESET;
RCustomer.SETCURRENTKEY("No.");
IF RCustomer.FINDFIRST THEN
REPEAT
IF NOT RManufacturer.GET("RCustomer."No.") THEN
BEGIN
RManufacturer."Customer No.":=RCustomer."No.";
RManufacturer."Customers name":=RCustomer."Name";
RManufacturer.INSERT;
END;
UNTIL RCustomer.NEXT = 0;
Hi,
probably a codeunit (run frequency / condition as you like)
RCustomer -> Record -> Customer
RManufacturer-> Record -> Manufacturer
Share
Report
All responses (
Answers (
RCustomer -> Record -> Customer
RManufacturer-> Record -> Manufacturer
RCustomer.RESET;
IF RCustomer.FINDSET THEN REPEAT
RManufacturer.RESET;
RManufacturer.SETFILTER("Customer No.",RCustomer."No.");
IF NOT RManufacturer.FINDFIRST THEN BEGIN
RManufacturer."Customer No.":=RCustomer."No.";
RManufacturer."Customers name":=RCustomer."Name";
RManufacturer.INSERT;
END;
UNTIL RCustomer.NEXT = 0;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156