Carri

Hi, I'm really stuck I have two identical DB's each being used by separate tour offices both on the same server. One of the offices books all the tours for both offices. How can I get all the tour requests to appear in one layout and still be able to communicate though the records (leave notes for the other office etc. - information changes often). For example if we're booking tours to the zoo. 4 could be though office 1 and 2 could be through office 2. All 6 need to be viewed on the same layout to book together as well as always be able to check availability etc. I don't know how to set up the relationships or the layout, any suggestions would be most welcome. They don't want everyone on the same DB - it's more complicated. Thanks

Hi I have 2 identical databases being used by 2 different departments. (Don't ask that's what they want) For explanation purposes both DB's have an identical table named PROGRAM Is it possible to display the records from both PROGRAM tables in the same layout in one of the DB's? Thanks Again

This was great thanks. Got me off to a good start, just need to work out to do it for every date separately, Thanks

Need to Calculate the number of classrooms needed: I need to calculate the number of classes that take place in given time slots and I don't know where to even start. Any advise would be much appreciated. Classes are scheduled at 00, 15 , 30 ,45 past the hour We need to analyse our room needs Thanks in advance

I really appreciate your time! There are 2 issues: Background: We're building tour schedules in an office where program coordinators and bookers communicate through the system to build and book schedules simultaneously. I have a "To Change" field that is a set of 3 check boxes. ch-changes the activity field text to red (if there is a change) N-changes text to green (if it's a new entry) canc.-strikes through the text if it's a cancelled activity. Issue 1) the Color and style of the text of the field activity: When a user checks a box the text is affected, if all boxes are unchecked I need the text to go back to black with no style in this case a potential strikethrough (I can make all go back to black but can't remove the strikethrough as well) This is what I have: case( PROGRAM::To Change = "Ch"; TextColor(PROGRAM::Activity ; RGB(255; 50; 50)); PROGRAM::To Change = "N"; TextColor(PROGRAM::Activity ; RGB(50; 255; 50)); PROGRAM::To Change = "Canc."; TextStyleAdd(PROGRAM::Activity; Strikethrough); //PROGRAM::To Change = "Canc." and PROGRAM::To Change = "Ch"; //TextStyleAdd(PROGRAM::Activity; Strikethrough); PROGRAM::To Change = ""; TextColor(PROGRAM::Activity ; RGB(0; 0; 0) and TextStyleRemove(PROGRAM::Activity; Strikethrough));[color:red](Don't think and works here) ) BIGGEST ISSUE 2)When I run the functions (when a user checks boxes) it relooks up the activity resourses that are based on the activity field losing any changes that a user has made. The activity is originally entered using a drop down from another table, it's as if the textcolor function or something in the calc reselects the same activity from the list as if it's new therefore resetting the resources back to the default. Refer to original post for activity and activity resouces background

Something in the calc is making the text disappear altogether when check boxes are checked together ... any idea what that could be?

Thank you I also need to remove a strikethrough if that check box is checked as well as back to black. I can't get it to do both. BUT that doesn't solves the problem of the resources resetting back to default???

Thanks for responding The activity resources are dependent on the activity and the activity is affected by the textcolor() function. Therefore when I use the textcolor() if put the same activity in again as if it were doing it for the first time, thus entering activity resources from the lookup.

Thanks for the responses In response to 1) The "activity" field is a line in a schedule for a specific date and time, the activity can change if for example it's unavailable for that date and time therefore the resources would need to be set to the new activity. So my understanding is that the way to do that is using a lookup. In response to 2) I need the activity text to go back to black or not be a strikethrough if the check boxes are unchecked. The reason the resources are resetting is because the textcolor()function does the same as if that activity was entered again for that date and time, as if it were a "new" activity.

Problem with lookup data being reset A field called "activity_resources" is auto entered in the PROGRAM table from the RESOURCE table by a lookup dependending on the field "activity" that the user selects. A user can change the text state of field "activity" using check boxes, this text state is coded in the calc of the field "activity" e.g. case( PROGRAM::To Change = "Ch"; TextColor(PROGRAM::Activity ; RGB(255; 50; 50)); PROGRAM::To Change = "N"; TextColor(PROGRAM::Activity ; RGB(50; 255; 50)); Evaluate(Quote(activity)) ) PROBLEM: Each time a check box is checked the "activity_resources" are set back to the default and any changes are lost. Is there a way to prevent this? Your suggestions would be much appreciated, I've spent so much time trying to figure this one out ... without succeeding! Thanks in advance

HI, I was having a similar probelm with Global fields and someone brilliantly suggested to write a script that on file close copied all the values in the global fields to another field and on file open copied them back in. That way you can use on server.

Question about the change from lookup to auto-enter: If data is already in the field that was calculated on entry (do not replace is checked off). And a user now wanted to use that same record but change the activity which is the field that the data is being calculated according to. Will it not replace the data of the old activity. If not how do I word around that as I need it to change if the user selects a different activity as the default resouces are now different (ref. to origianl post for example)? Thanks, Thanks and Thanks

Thank you!

Wow it's that simple ... thank you so much! What if we found an error in the original value and needed all those activities to be "relooked up" how would I do that?

Please can someone clarify this for me: What's the difference between setting a field as a lookup to a field in another table AND Making that field a calculation (in a text type) to be = to that other field? Here's my problem. Initially I need the field to lookup the values from the other table, but I only want that to happen once, once those values are in the new table I want users to be able to change them without risking loosing the changes when the original field is reselected. e.g. When an activity is selected from a list (TABLE:Program), the activities default resources are stored in TABLE:Program from TABLE:Activities. The users can adjust those resources to fit their needs BUT is they select that activity again in that same record they lose all their changes and the resources are reset to the default values from the lookup.