ChMisho

Thanks, Obvoisly I'll have to change the design or have a script to do the job for me onBlur of the field (which includes a plugin touch) I'm just wondering why Filemaker will have it in the GUI enabled, when it will not work. I was expecting to get a warning at least Regards ChMisho

Thank You, Calculation field would help, but I need a field that I'll to modify later and this numeric calculation is only the default value for the field. So i created test: as a calculation and a field test::C that is a Numeric that is getting the default value from test: (this time no relationship involved), but it doesn't work. And it sounds a little bit silly to have to change the primary+foreign key (nobody would update these) in order to get something recalculated for default value. I'm attaching the modified database Regards ChMisho

Hi, I have two tables Table1: test Fields: A - auto serial number, B - numeric calculation Field (testRel::data + 3) Table2: testRel Fields: ARef - references test::A, data - numeric data field I want to use one layout created for table 'test' and I want to fill in just testRel::data field and to get the calculation on test: which seem pretty simple BUT it doesn't work I'm attaching the database and you can try to create a new record. It shouldn't be a tough thing to do, but obviously I'm missing something. I tried in FileMaker 7 and 8 but it works the same way. Regards ChMisho