Hi, I'm new to FileMaker but not to databases but I'm developing an app in FM and need help.
I have 3 tables, the first one has the fields:
Code, Description and Notes (where code is the primary key and there's a relation of one to many with the field Code in the second table). It's records can be
Code Description Note
001 Traffic Violation Client on Fault
002 Parking Violation Any relevant note here