Auto Field Calculation

[Racer Bob]

Here is an interesting "thing" I ran into. I have two related tables. Some of the fields in table two, upon record creation, are to be given the existing value from fields in the related table one. The fields to use are in the calculations for the fields in the database info.

This works great if adding the new record for table two through a portal on a layout assigned to table one. However, if adding a new record to table two on a list layout assigned to table two none of the fields are given a value. I have to use a script to enter the values before commiting the record.

Can't find anything about this in the manuals or outside books, seems there are a lot of little "things" like this with the program. Sure would be nice if they documented this kind of information.

[David Jondreau]

Can you explain a little more? How are the values to be entered into table one? Is it an auto enter field or a lookup field? Or is it via the relationship?

G