Questions related to the FileMaker relational database + GUI.
Questions tagged [filemaker]
12 questions
15
votes
1 answer
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 problem I am having is I also sell bundles of…
shandery
- 151
- 1
- 6
2
votes
2 answers
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. The column may look like this (without ORDER…
Gary U.U. Unixuser
- 123
- 2
1
vote
1 answer
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 changes in mysql database then FileMaker database…
Kreya
- 155
- 6
1
vote
2 answers
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.
Colin
- 11
- 2
1
vote
2 answers
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 transferring it into an online system probably running on…
zerlphr
- 11
- 2
0
votes
1 answer
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 those rows where Table2.id_Table1 matches the…
Gary U.U. Unixuser
- 123
- 2
0
votes
1 answer
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 then read the values into separate fields. I…
LM12
- 3
- 2
0
votes
1 answer
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 FileMaker 19 64bit and the ODBC Client also…
cicciodevoto
- 101
0
votes
1 answer
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 spreadsheet containing member information and dues…
0
votes
1 answer
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 (beak_depthA; beak_depthB; beak_depthC);
valuelist =…
M. Beausoleil
- 101
- 2
0
votes
1 answer
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 data from the sql database into filemaker. Does…
Mary Weldon
- 1
- 2
-1
votes
1 answer
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 changes outside of production, but all of this is new…
ChrisW
- 11
- 1