New to FMP Help with relationships between tables, pop-menu list creates duplicates.
Ive just started using FMP to create a database, Im creating a database for our office central services.
I need some advise/ help with relationship between tables, its possible I dont understand how FMP uses relationships or Im using the wrong type, I think its unlikely that the problems is with FMP.
Ive created one table "Personnel" with details of employees including the field "name"
I have created a link this field "name" to the field "associated user" in another table called "assets" to save duplication.
Ideally I want to enter user records in the "Personnel" table and to be able to select them from a Pop-up Menu in a layout based on "assets". What happens is: when I select user1 from the pop-up menu in assets it creates a new duplicate record in the "Personnel" table.
Any suggestions welcome.
on Mac OS X 10.5.8