Jump to content


  • Posts

  • Joined

  • Last visited

JB2's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. I'm looking for a FileMaker "Mentor" to help with a project I'm working on and to help sharpen my FileMaker skills. I'm located in NH but this wouldn't need to be a local person. I'm looking for support via IM, email and perhaps phone. I have basic FileMaker skills and I'm looking for an expert to help sharpen my skills and troubleshoot questions. Please PM me if this is a service you can offer.
  2. I'm getting the same wheel when I start my computer then a message and a window that says "Where is Filemaker" I then need to locate FM9 in a list of applications each time I start my computer. I've tried to save the files as mentioned above (as compressed) them open in FM9 but it still does the same routine when I start my computer again. I'm thinking this may be cause because I purchased the FM9 Advances upgrade (coming from full install of FM 8.5 Advanced). This is really frustrating as it seems I need to quit FM 8.5, then find FM9 in the applications list (from the pop up) then I can get into FM9. I was thinking of uninstalling FM9, then trying to re install. Is this normal when upgrading from one version to a newer one? Any suggestions?
  3. Ok - I'm testing it out using your suggestions. I think I need to use the phone number initially, then once I've imported the data into different tables I think I can use "Replace Field Contents" for the PK's as needed. Once this is done I can change it back so the PK's can't be modified during data entry. If what I'm thinking is correct this would give me the matching PK & FK's as needed then I could base the relationship of the P&FK's and this should do exactly what I want, I think? I believe this is what you're saying when you mention only using these only as temporary relationships?
  4. Appreciate all the help! This is beginning to make sense. I should have clarified this, all excel sheets I will be importing will have phone numbers. With this in mind I'm thinking I can base the relationship on the phone numbers then use portals to view the related data on each table as needed? I think this will still show if a user has 2 numbers by the user showing up with 2 records if they have 2 numbers.
  5. The ID's they've given are the same for the most part (some have duplicate issues). So I wanted to use something like a serial number to generate a truly unique ID for the user on the import. I've done this on the USER info table, but not sure what needs to be done on the Phone info table? As it stands right now if I import the PHONES info into the table the FK from the USER table won't match as the PK is generated on the import of USER Info, not phones. Hopefully this makes sense? Sorry if this is very simple and I'm just making it difficult. Basically I don't have anything that is truly unique to the USERS so I would need to generate this. When I import the PHONES info I need to be able to see the USER info in a portal - Should the relationship be based off the phone number? Then I would import the info into the separate tables but still have pk_users (serial, auto enter) & pk_phones (serial, auto enter) on the correct tables.. Maybe I'm confusing how I should use serial numbers because of I'm importing...
  6. Fenton, Thank you for the answer and all the support. How do I make sure they fK_phone_info pulls the info from pk_user_info? I've tried allowing "Creation and delete" through the relationships and a bunch of other things I though would help but still nothing. When I import the Phone info after the User info is imported it doesn't recognize the relationship. If I put the fk_user_info on the Phone page its always empty so the tables don't seem to relate. Is there a function/setting that I should use after both imports? I agreed on the spreadsheets, it gets way too messy. Thats why I'm trying to use FM. Thanks for the help!
  7. Hello, I'm a Filemaker newbie but trying to learn as much as possible. I'm currently working with FM9 Advanced. I'm looking for some help/instructions with importing multiple files into my DB. I'm trying to create a database for a project I'm working on. There are a lot of different excel sheets needed for this project (each group involved has their own with specific fields). Some of the fields are the same (phone number, user ID etc). I'm trying to use FM to import all the different files and use relationships to pull the data together to show update, changes and info needed for different parts of the project. Here's an basic outline of the project. All help/suggestions are welcome as I'm very new at this but think FM will be the best solution given the number of people/files involved. I will be the only one accessing the FM files, all other user work off of spreadsheets which is getting very cumbersome. I have a DB with a list of about 800 people. All these people have specific phone number and a unique identifier (they are supposed to be unique but I'm finding some are not). I need to import all the user information, then use the files from other people to update information on a given user. I'm trying to use a few tables, one for each spreadsheet but some of the spreadsheets contain the same data (user names, phone number etc). The users each need to have their info updated from each spreadsheet daily. How can I import each of the spreadsheets and use relationships to show the necessary information for each user? I've tried using PK & FK for User & phone info but when I import into each table I can't view the updated info (for phone number/status info). It seems the 2 tables are still working independently even though I have the PK & FK's setup even using portals. Table 1 - USER INFO (name, email, ID) Table 2 - Phone/Status info (phone number's, ID, Status) -Relationship - fk_user_info = pk_phone_info - One user may have multiple phones After importing I can't view the information from the Phone/Status table through the relationship even in a portal. If anyone is willing to take the time to help with this through IM or Email It would be very much appreciated. Hopefully this makes sense? Any help/examples are very much appreciated.
  8. Does anyone know if you can use one field for either UPS or FedEx? I'm a newbie so I'm not sure how this should be done, but I'm assuming is could be scripted considering UPS generally uses "1Z" for the first 2 characters. I think if I told the script to look for the first 2 and if they were "1Z" to use UPS, if not use FedEx? Can someone give some advice on how to make this work? Thanks.
  9. kwlkshift - I'm also a newbie with FM, but I think I can help. If I understand you correctly you want to have one view where the user could enter their data, then another where the data would be displayed but not edited? Is this correct? If so, how is this database being run? Meaning: are there going to be multiple users? I think what your looking for is two tables and one using a portal to show information from the first table, but limiting the edit options in the second view. Again, I'm a newbie so this may be wrong. Can you let me know if this is what you're looking to do? Also, can you post what you have for this currently?
  10. I think the assigned number would be the best way to identify the user as well, as long as one user could have multiple numbers...I'm just not sure at all how I sould go about setting this up?
  11. Mr_Vodka - Thanks for the info. I've attached the file created from your suggestion. On the UserNumber table how is the fkUserID created/brought to this record? Meaning; I entered "John Doe" in the User_Table and he's pkUserNumberID 1, how will the fkUserId field pull this information into the UserNumber table? Hopefully this makes sense? Again thanks for the help. user_table.fp7.zip
  12. Hello, I'm new to using FM Pro 8.5, and have been working to try to grasp how to create a solution I need. I want to make sure I create this correctly so I don't start out on the wrong foot. I just can't seem to get my head around the relationship & table structure I should use. Here's what I'm looking to do: Analyze phone usage for individual users on a monthly basis. There would be multiple users with up to 2 phone numbers per person. The usage information will have a lot of different fields (I'll be importing this data from excel). I'd also like to identify the type of device they have. I've downloaded some samples on relationships, and I still cant seem to understand the best way to set this up. Any suggestions/help is much appreciated - It anyone can develop a sample it would be even more appreciated. Thanks!
  • Create New...

Important Information

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