Setting up my database - Please help
I really need some quick help on this one because I am new to Filemaker. Say i want to create and invoices.fp7 and a clients.fp7.
On invoices i have:
On clients i have:
I tried many ways of creating table relationships between the 2 files but they dont sync? If the fields in Name, Phone, Company on both files have a = relationship shouldnt it ne when i enter a new invoice a new client is saved automatically into my clients file or do i have to create a script?
My main question, and i have read all the manuals, is how to work with realtionships without running a script?
Im sorry if this is a silly question but i cant find an asnwer on this simple yet important question.
Thanks in advance!