Jump to content

Rapt Productions

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rapt Productions

  • Rank
  • Birthday 01/01/1978
  1. Hello, I've got a self-joining table in which each record can have a parent record and multiple child records within the same table, like so: (people) client vendor employee (artist) (performer) studio_artist actor (dancer) musician ballet jazz hip_hop modern belly (values in parentheses are parent records to the subset below) I'd like to be able to create value lists using this hierarchy, i.e. a performer list which gave me a choice between actor, dancer, and musician, and which in turn let me choose one of the types of dancer. Because of the directions in which my
  2. Well, at least I can take a little comfort in knowing that as a beginner, I should be having as hard a time with this as I am! These look like what I'm attempting to do - I'll try and figure them out. Thanks comment for your time and help!
  3. I'm sorry, but I'm still lost. How do I set this up in a layout or a value list? I created a portal in the layout, but I can't understand the results I'm getting...
  4. Are ChildTypes and ParentType the other occurrences of Type? And is ParentID the same as ParentTypeID? I apologize if I'm being dense, thanks again for the help.
  5. Yes, I think that's it - a single table in which each record can have a parent type. I'm not sure I understand how to set it up, though - you mention three fields, TypeID, Type, and ParentTypeID, but then where does ChildTypes come into the picture? Thanks so much for the help!
  6. I'm trying to create a table, "type." From "type," I want to be able to add table upon table - i.e. one type would be "people," and "people" would then allow for "clients," "personnel," "vendors," then "personnel" might have "editor," "cameraman," "admin," and so forth. What is the cleanest way to create this branching structure and allow users to define additional types (without creating redundant ones?) Thanks!
  7. Hello, I'm trying to figure out a way to prevent a single record appearing more than once in a portal. I don't know how to work with the data in the portal fields since they aren't treated as part of the table I'm trying to affect. In the attached file, I've got two tables, contact and company, with portals connecting them. I've set up a button to create a new record in the other layout (i.e. create a new contact from companies) or to go to an existing record. My problem is preventing the same record from showing up multiple times in either portal. I apologize if I'm not explaining very w
  8. OK, after a couple days of poking at the file I think I finally understand what's going on. I wish I really could invest the kind of time needed to properly learn filemaker; it actually happens that it's only part of my job, I work as a video editor and happen to be one of the two guys in the office who has experience with the software. So now I'm trying to convert my end-user experience with filemaker 6 (some four years ago) into developer know-how with filemaker 9! I did read David Kachel's White Paper for FMP Novices, but I only absorbed maybe 40% of it. In any event - I just wanted to say
  9. Thank you so much! This will probably sound ridiculous, but it never crossed my mind that a match field could also be a lookup. That's what's going on, right, that the match field in phone, email and address is looking up the ContactID? How do the company and contact ID value lists come into play? Thank you again for your help and advice!
  10. OK, here it is - I apologize for the mess, this is only my third database. So please feel free to point out any other mistakes I'm making, I appreciate any and all suggestions! Thanks again for your time. Oh yeah - login is "sony" RaptClone.fp7.zip
  11. Great! The Contacts_Multiple_Companies is exactly what I'm trying to do. But - I think I'm still missing something. I've tried to set it up in my Database. How are records created with Contacts_Companies? I made sure that "Allow creation of records" was checked, but - well, yeah, I think I'm missing something. It seems to me like something that would require lookups, but I couldn't find any... Thank you so much for the help!
  12. Hi David, I wonder if you could explain to me a bit more about join tables? I made a little bit of progress and got hung up as detailed in this post but it sounds like a join table might be the solution... what do you think? Thanks again!
  13. Thanks Robert. Truth be told, that went way over my head - but I appreciate it!
  14. Hello. I am trying to create a project management database for my company. I had planned to set up tables as follows [color:yellow]................company[color:yellow]...................phone number [color:yellow]............./[color:yellow]................[color:yellow]............../ Project[color:yellow].......................contact - email address [color:yellow].............[color:yellow]................/[color:yellow].............. [color:yellow]...............personnel[color:yellow]..................mailing address I created the contacts, phone numbers, mailing ad
  15. Hello, thanks for taking the time to read my question. I have an idea of what I want to do, but I'm mixed up about how to go about it. Basically, I have a "Contact" table and a "Companies" table. From the "Contact" table, I need to be able to A) Create new records in "Companies" : Select existing companies from a drop down From the "Companies" table, I need to be able to A) Create new records in "Contact" (First Name, Last Name, Phone Number, Email Address) Select existing contacts from a drop down list sorted by name I apologize for the disjointed explanation
  • Create New...

Important Information

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