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 payment information and then populate the correct member and their related table information. I read something I thought might be helpful about magic keys and tried to implement that but i'm wondering if my parent table needs to be my flat import table.
Filemaker Database. How to import to one table then copy information to a different table and populate realted tables
database-designfilemakerimport
Related Question
- Database Design – Understanding Many-to-Many Relationships
- Database Design – How to Use a Table When User Identifier Can Be One of Two Fields
- Sql-server – lookup the Primary Key in SQL Server from Excel Spreadsheet
- SQL Server Import – Fix Data Conversion Length Error
- Ms-access – How to update a yes/no field to yes when all related fields in another table are marked yes
- Sql-server – Windows 10, SQLServer Express (2019), Excel 2016 import to SQLServer error Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
- Mysql Database Design – identifying required patterns
Best Answer
You can import the raw data to a Temporary table. Loop through each record. Using Magic key, you can create both parent and related records.