Display fields from Resources

General support questions.
Posts: 25
Joined: Sat Aug 12, 2006 2:34 am
PostPosted: Wed Sep 06, 2006 1:44 pm
Hi John,

Love the solution,

I have added a price field to the resources and I want this field to display on the mini appointment layout, so that if you change the ApptResource_kf value the price field would update as well,

Please help.

Best Regards,

SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed Sep 06, 2006 6:20 pm
Most folks set this up so the price is "looked up into" the appointment- so if you change the resource for an appointment the price changes, but if you change the price of the resource all new appointments get the new price but the price change doesn't cascade down into older appointments.

If that's what you're interested in create a new field in the Appointments table called ApptPrice. Define an auto enter calc for this. Make the calc evaluate from the context of CalDailyAppointments and have it equal to

You can alternately make this a lookup of the same field in CalDailyApptResources. Lookups may be a better choice if you want to be able to override the price with a by-hand price.

Hope that helps.
John Sindelar

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

Follow us: