example.fmp12

File uploaded by danielkellett@mac.com on Nov 9, 2015
Version 1Show Document
  • View in full screen mode

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.

Attachments

Outcomes