As i said i am new to filemaker....I am working with the tutorials and I have created 4 tables which i have linked with primary and foreign keys.
We have a business that works with companies that manage multiple buildings. so each one client will have 100's of buildings I need to link.
I have done this with a one-many relationship using a primary key for the company table and a foreign key in the building site table.
I am creating a layout that displays both tables which i can get working to a certain degree...the main problem i have is I can only retrieve one record...i have gone into find mode typed in some details of other records i have entered but it still only retrieve the same record over and over again....
is there anyone that can tell me what i have done wrong????
i am getting very frustrated i know it can be done as i used to work with a file maker database before and it could do it....i just dont know how to make it do it..
any help, advise would be appreciated.