Version 1

    Can someone please help?


    I have been developing a Filemaker db for data entry & storage - attached version with dummy data in it.


    I have worked a lot on windows databases and was hoping to use SQL, but can't get that to work in Filemaker, so have tried this approach:


    The layout "new_events" is where a lot of the hard work of data entry is meant to be sorted out, and seems to work, but I want it to transfer that plus related information into "eventsummary".


    e.g. it's not necessary to enter a person's address is all you need is to find the FK and have that field populated in eventsummary.


    I CANNOT get data to copy over using the relationships I've put in place. Or do I need a script to do this?


    Typically it was working fine until I layered on some extra info !!!


    Any suggestion please?? My client is breathing down my neck.