Jump to content


  • Posts

  • Joined

  • Last visited

mixnplay's Achievements


Rookie (2/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges



  1. Hello all, I am working on putting together a system to track event sales. So here is what I have so far and what I am wondering is the best thing to do. I have made three tables. Venues, show dates, and daily sales. Venue is a list of Venues with details Show dates if the list of events daily sales is where the daily sales for each event will be updated and stored. What I am trying to figure out is the best way to updated the sales numbers. What I want to do is have a page with all the upcoming events listed and be able to enter the new sales record for each show. Can this be done in a portal? any and all help is appreciated. Ry
  2. Not sure if or how to do this but here is what I would like to do. I have built an event planning database. I need to add flights to events. I also need to assign passengers from my personnel table to each flight. What I would like to do is add a flight and assign it to an event. after that I want to be able to select what passengers will be on that flight have my value list only show personnel from the event that this flight is assigned to. Hope that makes sense. Thanks for the help.
  3. You Rock...... Oh yeah Happy new year too, I got it going and it makes sense. It took me a bit to figure out the button set field part in the portal but as soon and I set that up it all worked...Thanks for the help...
  4. Thanks for the welcome and the advice. So I added an id field and set it up to auto enter serial numbers. I modified my value list to include the id but only show the company and to sort by company. I was already thinking of ditching the schedule table and have now done so....I thought it would be useful but after getting into this a bit more I realized that it wasn't doing much. So I have my relationship set up between event and company for my company field. I am still not sure how get records to display the way I would like. Can I set things up so that when I select a value from my company field a list of events for that company are displayed, and then when I select an event from that list the record for that list is displayed and can be edited?
  5. so I am very new to Filemaker and am not sure how to make the layout function that way I would like it to. Here's what I have going on. I am making a data base to manage my event planning and make itineraries for my crews. So here is how I would like it to work. I have a table of companies. I have a table for schedule. and a table for each event. I would like to have a pull down list of companies where I can select the company that the schedule of events for that company will be displayed in a list. From there I would like to be able to select an event from the schedule and edit the details of the event in fields below. Ideally I would like all of this to happen within one layout. I have got all my fields set up and can flip through records but it will make working much faster if I could sort though that record as described above. Hopefully this makes sense and someone can help me figure out how to build this. Thanks Ryan
  • Create New...

Important Information

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