Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About FMD

  • Rank
  1. mferno - that gets to the heart of my question... if I import the spreadsheet in two phases, one to the Company table, and one to the Contact, there is apparently no mechanism inherent to Filemaker that will maintain the PK to FK relationship without assigning the PK and FK values to the spreadsheet prior to import.. What about creating a table in Filemaker that matches the spreadsheet structure, plus fields for the PK and FK, importing to there, and then moving the data, row by row, to the appropriate tables? I am envisioning going row by row, checking to see if the Company exists, if ye
  2. mferno - How will the relationship between the Company Table and the Contact Table be maintained?
  3. I have an Excel file in which a single worksheet has data that needs to go into separate tables. For example... Table: Company Field: pkCompanyID Field: CompanyName Table: Contact Field: pkContactID Field: fkCompanyID Field: ContactName So if I have an Excel Worksheet that is like this ColumnA ColumnB CompanyA Bob CompanyA Dave CompanyB Sara CompanyB James CompanyA Sally How to I automate an import of that into FileMaker into the separate Tables while assigning the key field values and keeping the integrity?
  4. I have an Order Layout with a portal to an Order Line Items Table. Certain items are "kits" where there are other items that are members of the kit. When a user selects a kit and enters a quantity the Line Items portal automatically creates the new rows using the kit items information and appropriate quantities. What I want to know is if there is any way to prevent just those rows that are members of the kit from being edited directly. Specifically I don't want the users changing the items or the quantities.
  5. comment to the rescue once again.. anyone else do any work around here? : thanks again comment.. you are rapidly becoming my FileMaker BFF :
  6. I have a table with a text field [Field_B] containing values between 00001 and 01000. In a script I am performing a find to restrict the recordset to only include records containing certain criteria in another field [Field_A]. After this is complete I then am trying to use the MAX function to return the highest value in Field B that remains in the recordset. However it seems to be picking the lowest number. For example. this is what I have left after a Find Field_A Field_B A 00250 A 00375 A 00400 MAX (table::Field_: returns 00
  7. AARGH! You're right.. I had even done something similar in a SQL DB I did years ago.. I don't know why I let a change in platform intimidate me so much.. especially with something as easily portable as table relationships.. Thanks once more comment..
  8. Hi gang! New to FileMaker and am working on a Contact database. I have built a CONTACT table and an activity table with a relationship of ACTIVITY to CONTACT. There are various different types of activity (email, phone call etc) that are stored as records in the ACTIVITY table. What I am trying to accomplish is a field that shows how many times a particular activity has been attempted with a particular contact. So if I pull up Sally I can see in my portal to the ACTIVITY table that the last activity entry was phonecall #3 for example.. I want the value stored with the recor
  9. That seems to do the trick.. thanks for the comment.. well.... comment :
  10. Hiya Gang! Little new to FileMaker development and I need some help on this one. I have a table that holds different categories for a contact Table: Category Field: pk_ID_Category Field: Category Then I have my Contact table with a relationship to the Category table Table; Contact Field: pk_ID_Contact Field: fk_ID_Category === Category::pk_ID_Category Field: First_Name etc.. etc... etc.. When I designed my layout for the Contact table I wanted it to where the user would see the actual Category as opposed to the Category_ID.. I created a Value List based on
  • Create New...

Important Information

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