Need Help setting UP DB mult time based records
I have a medical database. I started this DB with FM8 and now moved up to FM11.
I use on both OSX and Windows XP. We use it on both OS's
They are annoymous pt records for a cariac study. Each record has a unigue patient ID.
I need to add labs values for each record based on timestamp of 1-72 hours.
There will multile lab values for each timestamp.
I have initialy set individual data fields fore each time.
Time1 Ph1 C01 Sa01
Time2 Ph2 C02 Sa02
This make importing the data from a spreadsheet impossible.
Pt ID Timestamp Ph C0 Sa0
AAA1 1/8/2005 6:48 7.07 54 94
AAA1 1/8/2005 6:54 7.31 43 86
BBB1 1/24/2005 23:30:00 7.39 94 93
The amount of data for each patient vaires from a few hours to days.
Would an array be better? If so how is one setup in Filemaker.
I am part time user of Filemaker over the last three years. It a back burner job for me. In other words not what I was hired to do. I have learned it from these forums and experimenting.
Instead of separate time stamp fields, use separate records. Set up your table so that each record represents on row in your spreadsheet and the import process will work for you.