Jump to content

Search the Community

Showing results for tags 'database'.

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 Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • 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

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 17 results

  1. Hey, I have the following problem. I'm working on a solution for the owner of several restaurants. Each restaurant has meetings once or twice a month. How would I structure the tables so that I could have a layout on which I select a restaurant and then inside a portal I get a list of all employees. On the portal for each row I want to have a button or checkbox to mark if an employee is present or not. I already have the following tables: Restaurants, Employees and Meetings So far I have a relationship between the Restaurants and Employees table which I use to assign employees to a restaurant, and a relationship between the Meeting and Restaurant table, which allows me to show all employees that work at a selected restaurant using a portal on the meetings layout. How do I proceed to solve my problem? Do I create another table MeetingAttendees or something similar that I use to keep track of people attending a meeting? How would I create a relationship then to allow me to mark certain employees as present and absent? Thanks in advance, Mike
  2. Hello everybody, I am working on a Metanalysis DB and I have currently 2 tables: STUDY (Parent) and REFERENCE (Child). The STUDY table has a primary key __pK_StudyID, while the REFERENCE Table has a primary key __pK_RefID and a foreign Key _fK_StudyID. I have set up a relationship one to many between STUDY and REFERENCE so that __pK_StudyID (STUDY) --> _fK_StudyID (REFERENCE), and I have allowed record creation through that relation. Now, as expected, when I create a Portal of REFERENCE fields in the STUDY layout table, I am able to create new records (that is new references for the same study) and fK is automatically populated. What I would like to do though is to be able to auto-populate _fK_StudyID and add new records to the REFERENCE Table using the same layout (i.e. the STUDY layout) but without a portal. If I move the REFERENCE table fields into the STUDY layout (without a portal), everytime I create a new Study, a new reference is created and _fK is auto-populated as expected. The (hopefully silly) problem come when I try to create a new record in the REFERENCE Table (that is to add a new Ref. for the same Study): I have created a simple script that: - Create a variable: $StudyID to store the specific __pK_StudyID - Go to the REFERENCES layout - Create a New Record - Set field _fK_StudyID (of the REFERENCE Table) to have the value stored in $StudyID - Go back to the original (Study) Layout. Now the script works flawlessly, and the new records (i.e. new references) for the specific study are correctly created, so that when I go to the REFERENCES layout I can see them. Unfortunately, in the Study Layout I can see only the first reference I have created, not the additional ones. Of course, when I put the same fields of REFERENCE Table in the STUDY layout inside a portal I can see all new records I have created.... Anyone can give me a reason fro that ? At this time, the only way I have to create study related references (and see them) is changing layout and that is not the most efficient way to face the problem. Thank you always in advance for your help
  3. Dear fmforum,  i have a database with about 1000 items. each item has up to six images. i would like that each image has a filename that looks like this: "product id"_1.jpg the second image should have a filename that looks like this: "product id"_2.jpg  and so on.. where "product id" is the unique number for each item.  i have a script that exports the items image and changes its filename to: "product id"_x.jpg  is there a way to change the images filename when IMPORTING it to my database?  i attached a screenshot of my export filename script and another screenshot where you can see the difference between the filenames. the left one has the original filename and the right one has been exported and then imported back to my database and now has the right filename.  i am running filemaker advanced pro 12.0v3 on MAC.
  4. Hi, I would like some advise on how to setup a database containing a (biology) taxonomy. I'll explain the idea. I will have a main table with information about a species and the taxonomy linked to this information. It's the taxonomy part that I'm not sure about what is the best way op setting it up. It contain species, genus, family and so on. (About 10 rank levels) After searching on the web I have the following ideas. 1. I make one table containing: ID, name, rank, parentID Then creating 10 (for each taxon rank) table occurrences relating parentID to ID. 2. Create 10 tables, one for each taxonomy rank with: ID, name, parentID and relate these also by parentID > ID. 3. I haven't figured out yet how this would workand what the advantage is, but I read about a join table used for a taxonomy ? So one table with name and rank and one with id and parentid ? One thing is that somethimes I will have a level in the taxonomy missing, for example, there will be a species name, and the next one will be a family name, so genus will not be used. This isn't a problem with option 1 as the parentID will be there. For option 2 that means I'll have to make an empty record (but with ID and parentID) to not break the chain. What option would you advise me to use ? Or suggesting another better option. ;-) I also want to make a single form to add a new species with the connecting taxon as easy as possible. Will these different options have a big influence on this or does it require a fair ammount of scripting anyway ? I hope you can help me selecting the best setup for my database.
  5. Hiya, 1st of all - I have personally refrained from posting for help on a forum as I wanted to try and read, learn and solve my problems using trial and error! I am learning the FMP platform from scratch and am currently in week 2 of it. My question relates to a file I have attached to this post - the products area. For each product I have a number of 'size options' within it and each with their own unique SKU (stock keeping unit). Each SKU needs its own barcode. My job now is to produce a method to easily assign an 'available' barcode to a specific SKU. Barcodes are purchased from GS1 and are globally unique. I have a table hosting a pool of barcodes that I have available to me. They can only be assigned to one SKU and once assigned, needs to be removed from the available selection of barcodes in this pool. Issues I wanted to set a placeholder text for 'EAN-13' field in the product layout (this is the barcode). This field is a button! When clicked it can perform a script to open a popover or window containing all barcodes that do not have a 'ProductOptionID' assigned to it. How do I structure this script? Click the EAN field button - this sets the 'ProductOptionID' variable globally (is this correct to do) - [$$productOptionID] The script then opens the object 'Barcodes'. This is a popover button with a portal inside filtering all barcodes from the pool that do NOT have a productOptionID value in the foreign key field The script must then pause whilst I manually select a barcode and set a $BarcodeID variable? Or should I script it to pick a barcode at random from the pool of available barcodes (i've already set a script to give available a figure of 1 and unavailable a figure of 0) Then the script must put the BarcodeID variable in the product option record Is the above the right way to go about it? I also need a way to un-assign a barcode from a product and therefore remove the value from the product option id field in the barcode pool I have one more query. I have a relationship between Product Option table and the Barcode Pool. This relationship is O2M the barcodeIDpk with a lookup for the actual EAN (barcode) value on the Product Option table. When I set a barcode ID in the Product Option table - shouldn't the ProductOptionIDfk field update in the Barcode pool with the ID of the product option that the barcode is assigned to?? I am convinced I had it working earlier - but not anymore and cannot see to figure out why? See my relationship graph below and the solution attached. Thanks, Luke CRM Trial barcode.fmp12
  6. One of the database was corrupted. So we have created clone of that database and performed recovery. We have imported records from this recovered file into new clone file. This database is connected(relationship) to other database.e.g there are two database Department & employee database.These two table are created via DEPT_ID.I performed recovery on employee database. Department Employee DEPT_ID EMP_ID DEPT_NAME DEPT_ID EMP_NAME Now When I create new employee for XYZ department.It is assigned to the another department. How to solve this ? I checked the recovery logs and did not find any errors but found this line
  7. I'm in the early stages of building an app for iOS that would serve multiple purposes. A few of the options will send emails to a specific account that would be monitored for call-backs. We'd like few of the other options would be to place orders in our current Filemaker system, but I don't see a way to do that without FM:GO, and as nice as it looks, a dedicated database app is not really the solution we're looking for right now. Is there any way at all to make table updates or query FMP databases with native code similar to how I'd work with PHP+MySQL or C#+MSSQL, or am I out of luck?
  8. Position Title: Developer / Consultant Description of Duties: We need assistance developing, refining, and enhancing an existing FM database. Our current database is used to track and manage orders from beginning to end, including the review/approval process for purchase orders and check requests. We need to work the bugs out of what we have and expand into additional functions, like managing service requests. We are seeking someone who is available to assist with maintenance of the database on an as-needed basis long-term. Location: Orlando, FL Deadline: ASAP (August 2014) Position: Consultant Employment: Onsite Contact Details: evelynn@amberusa.com or 407-438-7847. Amber Diagnostics buys, sells, services, and refurbishes radiology medical equipment such as MRIs and CT scanners nationally and internationally. Disclaimer: FM Forums does not endorse or warrantee these positions please contact the poster for further information regarding the position particulars.
  9. How does one integrate individual filemaker files? I have a contact management file, a task management file and event management file but I want them to work together to create one big database that works together. Is this possible and how do I go about this?
  10. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that I'm not aware of. I have a background in software development, so the only solution that I can think of is writing a small program myself that does all the parsing for me and creates separate text files that contain all the orders and payments and other events that have been logged in the file. Then I could simply import each file into the table I need all the data in. So to sum everything up, my main question is if there is a way to somehow parse the text file before importing it. I know that you can create custom scripts in FileMaker but I'm not sure if what I need to do can be done just with that. Thanks in advance, Mike
  11. Hey, I'm fairly new to Filemaker and have a few question which I hope you can clarify. I have a Filemaker solution which I use for multiple customers. This solution exist of 2 files, a layout file and a database file. Everytime a new customer comes I copy the 2 files and clear the database so they can start fresh. The problem i have with this method is that when I change something in one solution, I have to change it in all of them one by one. This takes way to many time. My question is : What is the best approach for this ? Is it possible to split up all "modules" to separate file? So I have a module (separate fm file) called Invoices, Contacts , Inventory etc... and set the database structure and scripts in the separate file. This way I have 1 main file which is connected to all the "modules" and all customers have their own main file connected to the "modules", this way if I change a script or database in the "module" it is changed with all customers. Is this even possible? or is there a better way to approach this? I hope you can give me some more information.
  12. We have a FileMaker Server Advanced that hosts just under tables. Within those tables, there are hundreds (if not thousands) of database relationships. We just recently moved to a new location. Part of that move was implementing a new network schema and active directory. Is there a way to perform a batch update of all database relationships?
  13. Hi everyone,  I'm  new to Filemaker and have a beginner question about how to structure my tables (ERD'style).  Here's the situation:  I want to create a database in which I connect three entities:  1. Clients 2. Invoices 3. Artworks/Artists  - Clients can have multiple invoices - Invoices can have multiple artworks (however, every artwork is unique!! unlike generic products) - Artworks/Artists: every artwork is unique, and one artists can have multiple artkworks  *I would like to add a feature in which I can connect multiple pieces of art with multiple clients - I call this "interests". To avoid to creating a many to many relationship I created a separate item for this.  In the file I added is a first attempt to create a good relationship model. However, it does not seem to connect properly.  Any ideas on how to structure these entities in a good way are more than welcome. Tips, suggestions, and examples too!  Thank you,  ReepRutger  Â
  14. All too often, the Refresh Window script step is used with the 'Flush Cached Join Results' option checked. Sometimes this is through lack of understanding, but other times it is required to refresh those pesky relationships which have trouble re-evaluating. This article explains why Flush Cache can be detrimental on performance, and offers an alternative and more efficient method for refreshing relationships… Read the Full Article Here…
  15. Hello there. First of all im newbie in fm. I use the filemaker 16. I want to make a new base that keeps track of pages and especially registerstations and log ins. So i created 5 tables: "sites, user_names, passowrds, emails and account_descripion) I linked the tables with relationships. I created a portal witch have fields from three different tables, a field user_name from table user_names, a field password form table passwords and a field email from emails table. When i insert the first line(raw) in the portal ιτ seems to work. but if i try to insert values in the second line (say in a site you vave two accounts like facebook one ofiicial and the other one "a fake account") it seems that something is not working properly. I upload a 3m12sec video to show you what i mean. Please check it if you have the time. Also, the source file that im working on is in this link (filemaker 16 file): https://drive.google.com/file/d/1zW1jC6-dL1I9zEplo7Xw0dL3Wy8onKkl Thanks for your time
  16. Hello all, I am new to this forum and also to filemaker. I have seen my colleagues use it and I believe it is what I need for my purpose and have now installed FM Pro 14 to get going. I would like to organise my vast classical music recording library in my house that consists of many recordings saved on various types of media, including Lps, cassettes, Reel to Reel tapes (alot of them), DVD, VHS, BluRay and also on my computer hard drives. I am in need of some assistance and some ideas how to go about building a database with relationships as to facilitate searching for a specific recording or an artist etc. I would like to be able to display my collection by say tape number (considering also that my reel to reel tapes are of various diameter sizes) and want to catalogue them as they are filed in my shelves at the moment by reel sizes. Each reel of tape has a number on it, starting from 1. The large reels of tape (120 of them) are numbered from 1-120 and the smaller reels that are also grouped together are also number from 1 upwards. This is causing a bit of confusion as how to be able to set up a database. In the fields I would like to include as much information as possible for my collection, including details such as Composer, artist, soloist, orchestra or ensemble, and the contents of the recordings, such as Symphony No. 4 op.4 and all the details of the movements of the work. As these are home made recordings, each tape might have different composers on it. Also I would like to include technical details such as: tape speed, tape type, spool type, box type, and information if any blank tape is left on the reel ( and how many minutes) or if the reel is full. If searching for a particular composer or work I wish that the database would guide me also to all the recordings I have and on which media it is on (whether LP, Cassette etc). The more information I can put in to access my library and can search for anything depending on what I input in my search would be truly ideal. I looked at other programs but I believe as this is a very specialized database, I need to set up a database using such a professional program. I hope that anyone can help me and if anyone might have a similar database that they are happy to share and which I can try to adapt for my needs with some help I would be most grateful. As it stands I am struggling to search for anything specific in my library without going through pages and pages in an A4 filing system and believe there must be a clever way out there. Many thanks,
  17. 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!
  • Create New...

Important Information

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