Comparing Multiple Words in a Text Field across records..
I will very much appreciate if someone could help - we have a database containing all the details of the sales contracts we make.The most essential fields are :
Property,Purchaser,Products.Into the Products field,we enter many words seperated by a semicolumn - like "towels;bedsheet;bathing suit,etc" - for some contracts,there are
only a few words,but for some,over fifty.
What we need is to make sure that the Products for the same Property should not be sold to more than one Purchaser,and while entering a new record,FM should warn us if one or more of the Products were already sold to another Purchaser-preferably showing in another window the relevant record,so that we don't allow conflict of interest between clients..
We are using FileMaker Pro 10 on Mac (Snow Leopard) and Windows,and share the files via FM Server 10.
Thank you in advance for all your help.
Sounds like you need a related table of products purchased. That would change
Where each item occupies its own row in a portal of purchased items. That structure change, in turn, will make it easier to search for things and to produce itemized reports.