Hello, Damien. Welcome to FileMaker!
To automatically populate a field, you can use the Auto-Enter tab in the Manage Database dialog (choose File > Manage > Database). Select your field, then click the "Options" button in the lower right-hand corner.
Then use the Auto-Enter tab to enter your various options. You can enter data, a lookup (which is copying data from a related table), a serial number, data from the last record visited, creation / modification dates or timestamps (for appropriate field types), or a calculation:
thanks for the reply! What i am hoping to do is fill one record field with the number from another record field on a different table according to a serial #. I have tried a number of calculations (under calculated value) but have been unable to find out one that works. it needs to be exact because several other fields in the table depend on this field and right now the form entry doesn't fill this field...that means that I need to go into the table and manually enter the data (often dealing with thousands of records).
So what have you tried and what were the results?
I tried replacing the field entirely and a myriad of comands from the calculated valule and the look up field.
What i am hoping to do is fill one record field with the number from another record field on a different table according to a serial #
We can probably help you with the calculation needed, but we need more definition.
1) Is the "different table" related to the current record?
2) Is there more than one related record in the "different table"?
You say it's according to a serial number. Does that mean the two tables are related via that serial number? I'm assuming you have a relationship defined between the two tables. If not, then you probably need one.
But more description / definition of the problem is needed.
We need specifics. Please provide something like this:
The calculation I used was:
[actual calculation here]
The fields in the calculation are related like this:
[actual explanation of your tables and relationships]
The result I expected was:
[actual example of what you're hoping to produce]
The result I got was:
[actual calculated result]