Import From Filemaker Pro 13
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.
How to Import FileMaker Pro Databases into FmPro Migrator 1 Installation 1.1 Installation Tips 4. This document provides an explanation of the steps required to import info from FileMaker Pro. Convert the.fp7 files into.fmp12 files using FileMaker Pro Advanced 13. Exporting vCards from FileMaker Pro 13 HomeBase Software Don Clark ⋅ October 23, 2014 Back in August, I reached out for help with outputting Vcards from FileMaker and Douglas Alder was one of several (thanks to you all, btw) who reached out to help. FileMaker Pro Advanced 32 or 64 bit installed it has mattered I have tried both. I have also tried 14 with no updates and 14 updated to v2 I have tried importing and exporting data to and from in several different formats.
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. 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.
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.
Filemaker Pro 13 Upgrade
This is optional at this point. Any direction you can point me in would really help out.
Import From Filemaker Pro 13 Sierra
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. 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!
Filemaker Pro Advanced 13
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.
Comments are closed.