AnsweredAssumed Answered

Inserting a foreign key based on a field match from parent table

Question asked by ThomasSharp on Jul 9, 2015
Latest reply on Aug 17, 2015 by philmodjunk

Title

Inserting a foreign key based on a field match from parent table

Post

Hello, 

 

I am building a database and I've used access/SQL server before but I was strongly advised to use filemaker so here I am but struggling a bit with joining tables. I have related some small tables in FM14 manually and now I need to insert the main table and create the foreign key entries based on a match in the parent table. Here is a scrnshot of the parent table http://img42.com/4Mu0E+ and the company table is here http://img42.com/DZJUf+ 

This is just a small practice run as the actual data is 10 000+ rows. ( I don't know if I did the right thing joining the other tables manually but couldn't see another way) In SQL server a Joined update would do this but I have no idea how to do this in Filemaker... Any advice would be really helpful for me

 

Thanks

Outcomes