The first question is: when printing the records can you choose an option like "fit to page" or something similar. Some of my layout pass the printing limit so I was woundering if this is possible.
Not really. There is a scaling option that may work on a Mac system, but it doesn't work for windows. Best bet is to enter layout mode, use Printer Setup To select page size and orientation, then move/resize layout objects to get everything you want to see printed inside the page break lines. It's often necessary to create separate layouts in Filemaker--one for printing and one for data entry.
I) define a text field with this auto-entered calculation: Position & " " & Box & " " & and Freezer. Define a unique values validation rule on this field and your users will get an error if they enter a position, Box and Freezer value that matches a record that already exists in your database table.
II) Yes, you need a relationship that links your records something like this:
LocationTable::LocationID = SamplesTable::LocationID
LocationTable::LocationID should be an auto-entered serial number. Any fields that have the same exact data in both tables should be deleted from the Samples table. Instead, add the corresponding field from LocationTable to your SamplesTable layout. Be aware that the user will be able to edit the data in the related LocationTable record unless you use the Behavior settings in the Inspector to prevent this for each such field.
Thanks a lot for the reply, it was very useful. The secound part was not very for me clear but I manage to do it in a different way (without serial numbers).
If you do not use an auto-entered unique value for your location records, you risk problems due to data entry errors. If you enter or select the wrong value, then enter records in the samples table related to it, it is difficult to correct the errors without also breaking the connection to the related samples records as their link is based on this incorrectly entered value. Thus, an auto-entered serial number defined in Location is the safest method. If you have questions about how to set up this serial number field, feel free to ask.