By using this website, you agree to our Terms of Use (click here)
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.
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)
I managed to figure it with help from a Guru. Very simple and obvious
CSAnswers.RefNoteID=FSAppointment.NoteID
Online Members
