August 10, 200421 yr Newbies Hello how are you? I'm using Filemaker v5.5. I'm having trouble creating a lookup. I have two databases that I'm using. One (Customer) has information such as business name and address. What I'm wanting to do is create a lookup in the second database (Main) that will copy information from the first database (Customer). I've created a relationship field linking the two. I've define field (business name) in the second database (Main) to be a lookup field. But when I attempt to use that field (business name) the (Main) database it doesn't do anything. Please advise.
August 10, 200421 yr Your lookup should be such that when you enter the unique id in the CustomerID field (or whatever you have named it), then it will lookup the name and address from the Customer file. Entering or changing data in one of the fields that is looked up will not cause anything to happen; only changing the ID on which the lookup is based will have an effect.
Create an account or sign in to comment