Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About iwasnevy

  • Rank
  1. Thanks for your reply. Good to know about the multiple file paths, That may be a solution. To the terminology, yes you are correct in that I'm trying to move this to a separation model. The "Parent" database is indeed the UI and the "child" database is the user's data. I'd like to store the user's data file in their documents folder and the UI file in their applications folder. Since this app is still in development, I can continue to make changes to the UI file leaving the user's data alone and not have to deal with importing data with each future update (as you pointed out). I've
  2. I've gotten a lot of help from these forums in the past, but now I have a few specific questions that I need help answering. I know this is long, please bear with me as I'm trying to understand how this works… I'm developing a database that will be used for daily journaling. The development of the database has become complex enough that there are a couple entire tables dedicated solely to allowing the database to function more like an application on the presentation layer. These tables support things like calculations, navigation, controlling a log-in/change name/change password process, d
  3. Comment, your solution worked like magic! You saved me hours of work. Can I buy you a beer? PM me.
  4. duh. sometimes simplicity is best. my brain hurts. :hair:
  5. Found the sample file! Now don't laugh at the field names - Renaming some of the fields to make sense is on my list... : For now, I imported that 'contactname' field into the emergency contact field. I'll create some new intermediary fields to dump the data into while I work with it, probably usign comment's suggestion about the calc fields. File.zip
  6. Good idea. I'll have to play with your code tomorrow to figure out exactly what it does : so I can tweak it for stage two of the 'cleanup'. While I'm thinking about it though, how can I do a calculation that repsonds to a field with more than one word in it - for filtering out the record that are fixed, leaving only those with both a last and first name? I'll have to give this some thought.
  7. For what it's worth, once the data is split once, since some of the data contains a first and last name for each deliminater, (example below), I'll then run another calc to split those into a ParentAFirstName, ParentAlastName, ParentBFirstName, ParentBLastName, hopefully using the space as the deliminater. sample of field "ContactName" which contains a first and last name: Data in the field: "Mo: Susanne Clark Fa: John Walker There's even a couple that have things like "Mo: Susanne don't call", or "Mo: Susanne work 303-555-5555" Speaks volumes to planning a database for future
  8. @ Lee Sorry, I forgot to mention the file - I'm hesitant to upload it 'cause it's full of our actual customer data at this point. But here's the fields and the data it contains: Field: "ContactName" Data it currently contains: "Mo: Susanne Fa: John" It should be split to two seperate fields in the new database: ParentAFirstName "Susanne" ParentBFirstName "John" I think I have a copy of the file laying around without a ton of our data in it - I'll look for it and post it.
  9. LOL trivial for someone who knows calculations! : Thanks - I appreciate the help - I'll give it a try in the morning. No carriage returns, although some of the records deviate a bit from that mo: and fa: consistency with last names as well, and I've even seen a phone number or two and a couple records with a little note in there behind one of the mo's and fa's names. But as long as I know where the data's going, I can fix those little inconsitencies. But fixing 1200+ records requires a script with a calculation! @ Lee Smith: In a nutshell, I'm trying to take two seperate pieces of data
  10. Hi all Wasn't sure if this should go here or in the import/export forum, so forgive me if it's in the wrong spot. Here's the problem, and I *think* a calculation will solve it, 'cause I've seen some pretty slick calculations to modify and format field data. I don't even know where to start though, 'cause calculations are one of my weak points! I'm migrating some data from an older database into my company's new one. In the old database, there was a field labeled "contact name" which was abused with data designating both a mother and father's first names. At least they were consist
  11. I'm trying to solve a very similar problem. hopefuly someone can help. Bruce, that SearchFilter example file is EXACTLY what I'm looking for - I ran across it awhile ago and have been playing with it. However, what I'm trying to do is to filter portal results in this manner, and that's the part I can't figure out. To give you a better idea of what I'm trying to do; I've got a list of clients (names) in a column on the left of the layout, and clicking on one brings up their record on the right side of the layout. I've got that part done, using a portal to a TO of the client table as the le
  12. Thanks everyone - I figured it out. I ended up figuring out to do it comment's way - it turned out that his method is what was required for my data model. I knew to use a multi-key field to accomplish this, but I had to figure out first to make it a text field in order to accept a carriage return! Sheez - the simplest things sometimes... Sorry for the lame-brained post, but I had my head into it for far too long yesterday and just couldn't see the forest for the trees. Once I got some sleep, it went much smoother. :
  13. Hi All Maybe I'm high or something here, but I'm stupidly missing something important about many to many relationships, and I need someone to explain it to me. : I get the concept of a many to many relationship - I think I'm just having problems implementing it in Filemaker. I've got two tables. There's a primary key in each table, both set as an auto-calculated serial number as a record ID. There is also a join key in each table which is supposed to link them together. The primary key field can't be edited, but the join field can (I of course, have to enter a number in there to j
  14. Good points all. IdealData - a little clarification plz - Set $variable = Entry field: I get the set variable part, but when you say 'Entry field", do you mean replace that with the fieldName that they seached in? 'cause there's umpteen fields on the layout and they could search from either one, or do I create a new field to capture the search criteria into? Comment: Thanks - that sounds like about what I'm looking for, so I'll play with it. I agree with you about a global search being unecessary if the data is structured properly, (and it is) but it's a specific request from the c
  • Create New...

Important Information

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