Jump to content

Search the Community

Showing results for tags 'merge'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Platform
    • FileMaker Pro Advanced 17
    • FileMaker Pro 16
    • Command Line Data Migration Tool
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 9 results

  1. I am not sure if I posted this in the correct place, so please forgive me if not. I have: FM16 Pro Advanced (Have both Mac and Windows, but I use a Mac to develop), FM16 Server. I am trying to have a drop down value list populate with information from two different tables. Let me explain: I have a table called Products. this table contains information required for an individual product that we sell. Some of the fields inside the products table are: ID.pk, name, cost, price, etc.. I have a second table called Bundles. This table contains multiple items from the products table that become a single sellable bundled item. Some of the fields inside the bundle table are: ID.pk, name, BundleCost, BundlePrice, etc. As an example a product would be any one of these items (only one): Hamburger Patty, Lettuce, Pickle, Cheese. A Bundle would be called a Cheese Burger and it would be made up of several products like Hamburger patty, cheese, lettuce, pickle, etc. I have sales people and they need to enter the items that they sell. I have a value list (drop down) that populates from the product name field. this is working perfectly, however I have two additional needs that I am struggling with. 1. Each product within the product table has a number field called (sold individually). i use it as a true / false field. 1 = true 0 = false. some of the products we carry can not be sold individually but are still products. Similarly you would not sell a piece of lettuce individually, but you would still need that product on a cheese burger. I need to populate the value list with products that have the "individual sale" field set to 1. 2. I want to include all bundle names within the bundles table in the value list as well. A salesperson will click on the drop down and get presented with a list of all Products that contain a 1 in the "individual sale" field and all bundle names. Alternately I want to add some additional text in the value list to show a separator to delineate between products and bundles. This is optional at this point. Any direction you can point me in would really help out. My initial thought process is to create a table that I can populate with all of the products that have the "individual sale" flag and all of the bundle names by looping through the table assigning everything to variables to be displayed. I think this is a lot of work and could be prone to errors. thanks for your direction in advance. Rob
  2. Is there a way to merge two Filemaker databases (they have identical fields)? The problem is we have 2 people populating the database on two separate computers. The plan was to load Person A's work into Person B's database and visa versa without losing data but I'm not seeing a merge function nor anything on this topic on any forum or help center. Any suggestions?
  3. Hi All, I want to use Scribe as a mail merge tool, but I don't want the result to be separate files because there quickly become too many of them to manage. I came up with a set of short apple scripts to have Word insert each file into the document as I go, but it occurred to me that it would be much faster and simpler if I could do the whole process in FM then just open the result in Word. I didn't see anything in the documentation that seemed to cover this. Any ideas? Thanks!
  4. VickyLNesbitt

    Missing local name error

    Hi All Hopefully you can help me with a problem I am having sending mail for one of my clients. It's driving both him and me completely round the bend! We use the 360Works Mail plugin for sending bulk emails from our database, however I have one client who this doesn't work for. If I log in from my computer and send mails via his account all works fine, however when he does the same from his end, on the script step which creates the new message (EmailCreate) & sets the body (EmailSetBody), he gets the returned error: Missing local name Any idea what this means or what is the cause? I can't find a single clue from 360Works documentation, however some searching online indicates that the email address is missing the first part i.e @something.com, but this is not the case - the full email address is given as a parameter to the EmailCreate function. We're both using FM12, I'm on advanced though. Client is on a PC (XP or 7 I think) & I'm on a mac (mountain lion). Any ideas? And thank you in advance! Kind Regards Vicky Nesbitt
  5. I am trying to update our database and create more space. When it was originally developed, the bottom half of the screen was split into two separate tab panels and information has been stored that way for years. I would like to merge all tabs into one large tab panel. Is this possible?
  6. Hi, I have few FM DBs which has same table and structure inside. is it possible to create Master db where I will merge all external tables together to one master table? Solution shouldn't one time solution but dynamic.
  7. Hello! Although I used FileMaker 3-4 years ago to build a nice database to organize my material, research, and notes for my creative writing projects (and I still use that same database today), I haven't actually built anything new in FileMaker since then, so bear with me! My current objective is to create something that approximates a merger between the 'Starter Solution – Contacts' and the 'Starter Solution – Content Management' templates. The 'Contacts' starter solution template is a pretty great foundation for what I need in order to organize personnel because I'm doing a pretty large project wherein I will be working on a variety of smaller creative productions for which I will be collaborating with dozens of actors, actresses, musicians, writers, photographers, videographers/filmmakers, models, etc. The 'Content Management' template is only so-so for what I would like in order to organize a database of material, ideas, and notes (I will be primarily authoring or writing most of the scripts and sketches to be performed or produced as well as being the overall manager of all the creative content made). One concrete problem is that I'm having trouble creating a conditional value list, where I first select the "medium" or the type of content that will ultimately be produced (writing, still photography, or video/film), then according to my selection, the options for the next field will be narrowed down to a pre-determined set of choices (for example, if I chose 'still photography,' my options for the next field would be something like: "nature photos, portraiture photos, action photos, architecture photos, object photos," etc.). I did find a guide for doing this, but it's not quite working for me. If anyone knows the best (and possibly simplest!) way to achieve this, I'd very much appreciate it if you shared this with me. Anyway, I would also like other fields on Content Management database, like logistical information (date and time of production, location of production, etc.). But a key feature I would like is for it to be connect with the Contacts database. By this I mean that I can plug in perhaps 3-4 potential actors who might be compatible to cast for a specific role in a specific script in the Content Management database, and after plugging them in, I'd like for there to be some kind of button or function where I can click each of the candidates' names (or click a button next to each name) and be directed to their record or profile in the Contacts database (which will have their bio, photos, contact info, etc.). I appreciate any tips! I know I can find all of this out simply by researching more, but I was just hoping perhaps someone had a quick solution, as it seems like the need for combining these two types of databases might arise fairly often. Thanks!
  8. Hi there, I am making cutom import and export from/to excel documents. Is there any way to merge excel cells in scribe? I can easly find out which fields are merged when importing. two nested loops and if second col or row is empty while reading i consider it merged. Problem is while exporting. I need to add new rows to excel documents and keep 1 column merged for each set of rows(like in sub summary but vertical). Thanks in advance for any help. Have a nice day.
  9. Over the past ten years our organization have been using a PO database solution to store all purchasing information. Each year the layout would change to illustrate which year it represents. We would like to merge each of these databases into one for better searching capabilities. Is there an easy way to accomplish this task while still maintaining data integrity? Thank you!

Important Information

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