How to update record based on information in current layout ?
I wanted to find easiest way of updating rows of certain table based on current displayed data
For example I have two tables
|client ID||client name||ssn||dob|
|clientid||progress Id||Progress notes||date||Goal|
|002||1||First session||1/1/2011||check health|
|002||2||second session details||1/31/2011||Follow up|
|001||1||First Session for Client||3/2/2011||
|002||3||Thirds session for this client||4/1/2011||
I have layout where Progress Notes are displayed for a particular client. I wanted to achieve following
1. Current view should show me all the Progress Sessions for a given client.
2. When I click on add new record, it should go to progress table and read the last progress ID for a given client and increment the progress
The goal is to increment progress ID only for the relevent client, in above example client 002 visited twice and it had two progress sessions.
Sorry for the long post, I am fairly new to the concept of Relational DBs and Filemaker!
Thanks for your help!