using key fields to share calculated data between two tables
HI. New to this site, so please bear with me.
I am a teacher who has created a database for my grades. I have a final project that is team based, and I would like to create a table where I can calculate the grades of the final project, one for each team, and then have that information show up in the main table.
I have successfully created a simple key field using sequencial numbers, but I cannot replicate it using a caluculated field. Could someone walk me through this, or tell me that FMP does not allow this to be done?
Thanks in advance.
Great forum by the way. Very helpful.