AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Linking the CSAnswe...
 
Notifications
Clear all

Questions Linking the CSAnswer information to the FSAppointment Table

 
Everything Else
Last Post by NickSM 6 years ago
2 Posts
1 Users
1 Reactions
2,224 Views
RSS
NickSM
Posts: 46
 NickSM
Topic starter
June 25, 2020 4:38 pm
(@nicksm)
Trusted Member
Joined: 6 years ago

I've currently created four Attributes on the Field Services Appointment (FS300200) form to show manually entered start and finish kilometres. This field will then flow into Forms and be the basis of reports throughout the system.

image

My problem is, how do I link the CSAnswers to the FSAppointment Table. There doesn't seem to be a logical join. The last time I used this area the RefNoteID and Attribute provided the link. I know that this changed so that most major tables show attributes e.g. STYLE_Attribute. Unfortunately this isn't the case for FSAppointments, FSAppointmentDets (my next guess)


Topic Tags
Service Management Attribute
1 Reply
NickSM
Posts: 46
 NickSM
Topic starter
June 25, 2020 9:47 pm
(@nicksm)
Trusted Member
Joined: 6 years ago

I managed to figure it with help from a Guru. Very simple and obvious

CSAnswers.RefNoteID=FSAppointment.NoteID


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Change Location DescriptionField attribute to pull from another DAC
    2 years ago
  • Routes in Service Management
    7 years ago
Topic Tags:  Service Management (2) , Attribute (4) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 15 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×