Is it possible to relate fields?
Is it possible to relate two fields like this:
If customer_name = already existing customer from previous post = customer_number
If not = new_customer_number
Is this possible??
You just described a calculation field. Is that all you need?
Sounds like you are actually relating records, by customer name, in order to look up a customer number.
I want filemaker to automatically recognize the Companys name and fill in the supplier number.
In what context are you doing this. In other words are you creating an Invoice, start typing customer name, if it exists have it fill in the Company name and supplier number?
If so, it depends on how your relationships are set up, etc. This is pretty common with things like picker lists, and the usual set up of relationships in you can see in the Invoice Starter Solution.
If set up properly, when you pick a Company's name, all the relevant and related data will populate.
You can set up a relationship that matches by name to look up the number.
See this thread for more info: Auto Fill
And your relationship can match to records of a different table or to a different Tutorial: What are Table Occurrences? of the same table.
Retrieving data ...