Questions tagged [filemaker]

Questions related to the FileMaker relational database + GUI.

Filter by
Sorted by
Tagged with
14
votes
1answer
3k views

Database design for products with bundles of products

I am building a database system for my retail business. I have set some tables which are: Product Purchase Sales Balance All are connected one another and are able to show my inventory level. The ...
2
votes
2answers
184 views

Very tricky: Can't update a sequential list SQL-92 ( Filemaker)

I have a quite simple problem, but the solution is very tricky. I'm trying to solve this for months: There is a column "SortID" that needs to get updated with sequential integers, starting from 1. ...
1
vote
1answer
1k views

Microsoft Access database to FileMaker Pro

I have all my customer details in Microsoft Access. I want to transfer all this data to FileMaker Pro. I hope there is a way to do this. If so please help me.
1
vote
1answer
479 views

How to add External data source into MySQL?

I have two database. One is a FileMaker database and the other one is mysql. I want to use this database in mysql. I created ODBC data base connection so that I can sync both database e.g when I make ...
1
vote
2answers
1k views

How to model double relationships?

Background: I have designed a solution for Filemaker to input data into a Question Database. After we are done with inputting data into Filemaker, we will be exporting the data as excel and ...
0
votes
1answer
33 views

Remove extra return from median calculation

I have a FileMaker database where I want to calculate the median value of 3 different fields. I used the code that can be found here. In my setup, it looks like this: Let ([ beak.trait = List (...
0
votes
0answers
27 views

Filemaker Pro - Proper design approach for type/subtype database?

Currently working on designing a FileMaker application to keep track of A/V equipment in a company. The application needs to be able to display each room/location with the A/V equipment that is ...
0
votes
1answer
54 views

Filemaker Database. How to import to one table then copy information to a different table and populate realted tables

I'm using filemaker to create a union membership database, the problem i'm having is that you can't import files into related tables. Basically i'm trying to figure out how I could import an excel ...
0
votes
1answer
33 views

Safe to use odbc link betw Filemaker 11 Server & SQL Server 2012?

I’ve established a successful odbc connection between filemaker 11 Server and SQL Server 2012. Filemaker, inc has not certified this compatibility between the two but I have had no problems importing ...
-1
votes
1answer
123 views

Copying a Filemaker Database running with an ODBC Connection

Work has a custom Filemaker Pro application, and it has an ODBC connection for the company website to access. I want to migrate the FMP database into a MySql/MariaDB database to tinker on Schema ...