Relating clients notes

General Information about upcoming products, upgrades, etc.
Posts: 25
Joined: Sat Aug 12, 2006 2:34 am
PostPosted: Mon Apr 02, 2007 4:43 am
Hi,

I have created a notes field on the CCCalAppts table which relates to notes for that appointment. I would like to include a portal showing all of the notes from previous visits, so that you could check how a treatment was doing etc...

Am also having a problem displaying the type field, its set as a drop down list with the possible types value list, but when you select it it displays the value with a ? at the end! any ideas

any help or ideas would be much appreciated,

Thanks and best regards,

Roy
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Apr 02, 2007 1:55 pm
rservis wrote:I have created a notes field on the CCCalAppts table which relates to notes for that appointment. I would like to include a portal showing all of the notes from previous visits, so that you could check how a treatment was doing etc...


Hi there.

So where would you like to see this portal? On the appointments record or on the contact's record? From an appointment you'd make a relationship to another table occurrence (TO) of the CCCalAppts table based on the Contact's ID (then add a second relationship criteria where the Appointment ID does not equal itself this will make sure you don't see the current appointment in the portal. Sort that portal by date descending and you should be set. The relationship is nearly the same from the contact except that it is just based on the Contact ID.

Am also having a problem displaying the type field, its set as a drop down list with the possible types value list, but when you select it it displays the value with a ? at the end! any ideas


Not sure I have much of an idea what that could be. Could the "?" be in a second field that just looks like it is the type field?
John Sindelar
SeedCode

Return to FileMaker Products (General)

Who is online

Users browsing this forum: Google [Bot] and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: