Is it possible to pull the value of a field in one record to another field in another record (same database)? Let me explain a little bit what the setup is. I've created a weight watchers daily journal to allow users to record what they ate and the points associated with the food. (WW uses a points system, and you get a range of points per day.) I have it set so the user may view only his own records. The DB tracking is set to ID; however, as a side comment, I'd love to know also if there's a way to limit each user to only one entry per date. I didn't set date as the track because there will be multiple entries for each date, but should only be one per user. Anyway, back on track...I've used javascript to get the journal to add up the points per meal and for the day and, based on the points range selected, to fill in the points available, then finally to subtract points spent from points available, resulting in a points saved field. What I would like to do is somehow have that "points saved" field from today pull in to tomorrow's "banked points" field. Is this even possible? If so, how would I go about doing this? It will have to be dependent on the userid and the date, as well.
Thanks!
Melanie
Thanks!
Melanie