falkaholic Posted May 2, 2002 Share Posted May 2, 2002 I'm making a tour managment database. As of now, I have crew and bands related to the tour. To add crew or bands to the a tour, i have 2 portals; one listing all crew, one with crew on the tour. I have buttons in the portal to add/remove them. That works fine. But what I want to do is filter out crew that are on the tour already so they can't be added more then once. Can anyone think of a way to do this? Link to comment Share on other sites More sharing options...
andygaunt Posted May 2, 2002 Share Posted May 2, 2002 Hi, I did something similar for events. The way I got around it was to create a field in the users database for on event. This was a return delimited list. Everytime a new event was created that id was added to the users delimited list. Then the portal was set to display users with a matching project in their record. This was linked to a global field in the main database. So, all users appear in this portal where you can add them to the event. now, when adding a member to that project a new record was created for that user in the events members. Then a set field script was run, substituting the project id for that user in the on event field with project id & ":0" This removed the user name from that portal, stopping them being selected twice. Another portal sat to the side listing all the event members. Also, you can reverse this so you can remove the user from the event, and they appear back into the other portal. If you want an example I should be able to put one together for you. HTH Link to comment Share on other sites More sharing options...
falkaholic Posted May 2, 2002 Author Share Posted May 2, 2002 Thanks for the reply... I think i get what you mean, i will try some variation of it. Link to comment Share on other sites More sharing options...
The Bridge Posted May 2, 2002 Share Posted May 2, 2002 Just did a test that works: Define 3 fields: In Master database: g_Avail_Crew_Key (either a global number or calculation) = 0 g_Tour_Crew_Key (same as above) = 1 In Related database: Crew_is_on_Tour_n (number field, stored, auto-enter "0") Define 2 relationships: Avail_Crew (g_Avail_Crew_Key->Crew_is_on_Tour_n) Crew_on_Tour (g_Tour_Crew_Key->Crew_is_on_Tour_n) Define 1 script: Toggle Crew_is_on_Tour_n Set Field [Avail_Crew::Crew_is_on_Tour, Choose(Avail_Crew::Crew_is_on_Tour_n, 1, 0)] Go To Field [] You can put Crew_is_on_Tour in the Avail_Crew portal and specify it as a button that calls Toggle Crew_is_on_Tour_n. You can make a similar script to toggle the crewmember off the tour. [Edit: Changed some names to preserve Crew/Tour analogy] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8194 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now