Page 1 of 1

Display fields from Resources

PostPosted: Wed Sep 06, 2006 1:44 pm
by rservis
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,


PostPosted: Wed Sep 06, 2006 6:20 pm
by John Sindelar
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.