Auto Title

[Lois]

Hi
i want to create an auto title on my form. i have used the formula
=Nz([CUSTOMER NAME],"") however it is returning the Customer ID because of the relationships i assume (see attached) is there any way i can get the actual customer name in the field?

[Stingaway]

If the data source of your form is a query, you can add the table to the query and pull down the related customer name. If it is not a query - make it one.