Jump to content

Tiny Bubbles

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Tiny Bubbles

  • Rank
  1. Thanks for the suggestions. These are the kind of things I have been trying. Let me get a bit more explicit. This is for a week long seminar. There are courses on Tue, Wed, Thur, Fri, and Sat. Participants sign up for 3 choices on each day. If a course is closed, we go to the second choice. The databases are set up as follows: Summer04 (partipants file with a MCTue, MCWed, MCThur, etc fields). It is linked, through the mini course IDkey (01, 02, 03, 14, 25, etc.) Now, this may be where things get tricky. Course 01 is offered on Tue and Wed but not Thurs and Fri. This means the relationships are with MCTue=IDKey, etc. Over in the MC04 file, I have a calculation field to get the count zc.particpantTotalWed.c=Count(Summer 04| MCWed::WedMC1) This works fine, but when I use it to validate entries on the Summer04 side, it doesn't work. Count(Wed MC::zc.participantTotalWed.c) >= 20 I thought it might have something to do with a self join, so I tried that on the Summer04 side, still no dice. Count(Self We::WedMC1) >= 20 So, I need this to work on the Summer04 side because that is where I enter the IDKey for each day. It is here that I need it to say: Sorry, that course is full, try another if the course is full. Any further ideas, kind folks?
  2. This is a toughie I have been banging my head on for about two years, I was about to throw in the towel when I discovered this forum. I have have a database of mini courses and a database of participants who wish to sign up for said courses. The "full" point for the courses is 20. Now I can keep a running total of the number of particpants signed up, but I want to put this info into a caculation so when I try to assign someone a course that is full, I will get warning "This course is full, try another." Thing is, I have not been able to automate this, and therefore, I still us the "hand" system to tell when the course is full. Then, I add a validation calculation, "MC 20 is full, please try another." I am sure you can imagine the problems this creates. Not least of which is me putting someone in a course that is full or not offered on that day (this has happened more than once.) So, any thoughts? I will be out of the office until Monday. Have a spooky weekend everyone!!
  3. I have been all over the books and the forum site, but can't find an answer to this qusiton: Is it possible to use a container field in a calculation? I have a file of mini courses. The faculty will be able to designate a difficulty level from 1 to 4. I have a star graphic known as DesStarGraphic1. I would like to produce a caculation so if the difficutly level is one, only one star graphic shows up, if it is 2, 2 graphics show up, etc. I have written a nested If statement that produces correct results for 1, the caculation falls apart on difficulty 2 (meaning, nothing shows up). I am using this code in the calculation (called DesLevelCal): If (DesLevel="1", DesStarGraphic1, If DesLevel="2", DesStarGraphic1&DesStarGraphic1, If DesLevel="3", DesStartGraphic&DesStarGraphic1&DesStarGraphic1, DesStarGraphic1&DesStarGraphic1&DesStarGraphic1&DesStarGraphic1))) It may be as simple as not being able to do this (that is add up the graphic fields) though it seems like it should be possible. I make the target field (DesLevelCal) a repeating container, still no dice. Any ideas? I am posting this Thursday, but won't be back to answer until Monday. Have a great spooky weekend. I will be haunted by my problem.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.