Before "jumping in", have you looked at basic FM scripting?
Check out Lynda.com for a FileMaker 15 course. There's even a free 10 day evaluation.
There are TONS of tutorials out there, but for my money, few as good as the Lynda.com series. FileMaker also has free information available.
HOPE THIS HELPS.
1 of 1 people found this helpful
Take a look at the Invoices starter solution. This is pretty important but basic and required knowledge, as it is used in many DBs, and the basis of many relationships.
You also need to understand Lookup and calculations, or after you solve this problem you may create several others, and head down the wrong path-maybe requiring a partial or complete rebuild.