Jump to content

JB2

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About JB2

  • Rank
    novice
  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)
  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 r
  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 trul
  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 mes
  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 di
  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? Als
  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
×
×
  • Create New...

Important Information

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