Parts Master Lookup Problem
I am new to databasing and I am using FMP 10, so this might be a really silly problem.
Basically, I am trying to use a relationship (between 3 fields in one table and one field in another) to create a lookup for 3 other fields in the first table. Whenever I try to perform the lookup, information is only auto-entered into the fields after matching information has been entered into all 3 of the original fields.
Any assistance is much appreciated!