"Spreadsheet" within a record??
Posted on 2005-05-08
I am not sure of the proper terminology, but here goes:
I am using FMP 7 in Windows to track what I do when I visit a client. It is simple enough to create a text field that tracks all the items I did during a visit, but within that same layout I would like to have a way to track purchases that I made for that visit....and make sure it stays tied to that record of that visit.
One way I could think of doing it would be to create a two column "spreadsheet" with a field. Column 1 would be the name of the purchased item and column 2 would be the cost. The total of column two would then need to calulate to a sum of all purchased items.
I bet I could do this by creating a relationship to another table using serial numbers, etc, but I am hoping there is something simpler.