Filemaker pro 11 creating new record and a table content from a different record is copied into it.
Im using a database with tables, fields and many relationships for a PI and Im having trouble with a table. Whenever i create a new record it is somehow linked to that same table in another record showing the same things that are in there.
For instance I have 10 records and in this table it says a patient underwent a hysterectomy in record 1. Then i create a new record (so this would be record 11) it will have nothing filled out except for in that one table it says patient underwent a hysterectomy. And if I delete the contents for that table in record 11 it will disappear in record 1 as well.
How can i remedy this situation?? any help would be much appreciated!
using a 2011 apple with Mac OS X