Hi, I'm very new to filemaker pro and am having some problem with relationships.
I'm trying to make a database based on an elderly care facility, one table has the names of the residents ("Resident Info" Table, their address and the date they came into the care home, and the other is a table with details of people who pay for those individual residents("payee" table).
What I want to create is a field in the Resident Info table called payee, where i can select from a drop down list the name of the payee who pays for that resident. so i create a field in both tables called payee and link them. But when I add data to the Payee table and then go back to the resident info table it doesnt work. If anyone can offer some insight i owuld be most grateful.
