Questions tagged [filemaker]
Questions related to the FileMaker relational database + GUI.
12
questions
0
votes
1
answer
212
views
UPDATE & SELECT & INNER JOIN combined (SQL92) — How?
I have two tables with the following columns:
Table1
id
Sort
dou
and
Table2
id_Table1
Sort
and I need to read all values of Table1.Sort where Table1.dou = 1 and write them into Table2.Sort, into ...
0
votes
1
answer
20
views
FileMaker: creating a plot from a variable list
I would appreciate help with a Filemaker question about creating an x-y plot.
I have a list of numbers to plot for x and a list of numbers to plot for y. I read the numbers into separate variables and ...
- 3
0
votes
1
answer
36
views
Configure FileMaker Pro OBDC data source administrator
I have a database created by someone else in FileMaker and I was trying to connect it to QGIS.
As a newbie, I was looking around and found out I could do it passing throught the ODBC.
I installed ...
- 101
0
votes
1
answer
235
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
1
answer
56
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 (...
- 101
-1
votes
1
answer
248
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 ...
- 11
0
votes
1
answer
43
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
vote
2
answers
2k
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.
- 11
2
votes
2
answers
252
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. ...
15
votes
1
answer
6k
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 ...
- 151
1
vote
1
answer
671
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 ...
- 155
1
vote
2
answers
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 ...
- 11