the606

Basically I have a small test db setup with three tables. The person. The report comments the persons record including report comments. I need to get the comment 2 field to autofill based on what is entered on form test1234 in comment 1. I cant seem to get it to do this, im sure its simple but....... I need to save these comments so that we can go back and reference them at any time in the next 10 years. Each year the table containing the comments will changes hence me saving them against the persons record. Any tips on making this field autofill against comments1 would be greatly appreciated. test1234.zip

That's great, thanks for spending the time to do this. Ill have a play and come back. Much appreciated.

Hi, Im stuck with something really simple, please can you give me some assistance as I'm having a brain block. I have two tables, Lets say they are called cars and customers. In the car table it will contain the following. Registration number Model Engine size no of seats. In the customer table it contains information about the customer but also the info about the car that they own (using same field names as above). I want to be able to type in the registration number in the customer layout and for it to look this up in the cars table and 'autofill' the fields (model,engine size and no of seats) in the customer table based on what it reads from the car table. hope this makes sense, I know its simple but im stuck... Any pointers would be appreciated.

Hi, Been working on database for years but just started on Filemaker Pro Advanced 12. Im designing something for a friend and im having trouble setting something up as I cant seem to get it clear in my head. So basically I have a couple of tables, one of which contains all of the 'customer' information (customer id, name, address etc). I have another table with some reporting entries in it, these are in two languages as I need to allow the account manager to select the English comments but the equivalent foreign language comment is saved against their 'record' (in another table with the year as a key as this will not get updated). Im having trouble setting up a new layout to select the comments but actually save the foreign language version...... I think im a bit slow today Any help would be greatly appreciated.