Keith Cannataro

Thanks folks. The info you provided got my problems solved for both table lookup and for the portal problem. Appreciate your help.

Ahhhh, I see it was very simple, as that is exactly what I had setup for the Vet Visit table Dog Name field.....however, I am not sure if FM has what I was expecting without creating scripts? What I expect is to NOT use Value Lists for the Shot Records and Vet Visits. What I am expecting, because Dog Name is on both these 2 tables and there is a lookup linking Dog Name in each of those tables to Dog Name in the Dogs table, is that when I go to Dog Name field in Vet Visit or Shot Record, the only names that pop up are those contained in records in the Dogs table. A similar example. I have a table Vet Clinic and a table Vets. The Vets table links to Vet Clinic via Clinic Name. When entering records in table Vet Visit or Shot Record, when I get to the Clinic Name field, I was expecting the list displayed is taken from Clinic name of records in Vet Clinic. Additionally I am expecting that the Doctor names that are pop up displayed to select are only those doctors at the Vet Clinic that was selected in the previous field. Plus, still uncleare of what is wrong of why the Portal records are not displaying. Thanks again for any additional help.

I have now attached a clone (zipped) of my Dogs database. If you can help me out, please read the details on this post and this one on portal problem. http://www.fmforums.com/threads/showflat.php/Cat/0/Number/113254/an/0/page/0#113254 I am wondering if FM is less sophisticated than I thought and that all the things I expected that were built in must be controlled with scripts. Please check it out and thanks for any help. DogsClone.fp7.zip

I have a clone of the db, but how/where do I put it so someone can check to see what I did wrong. thanks.

I'm guessing you are indicating that this question has been posted before. I searched and don't see it. Can you provide the link to this other posting so I can see the discussion and solution? Thanks.

I just got Filemaker and this is the first time I'm trying the portal capability. I have a table Dogs, with one entry for each dog. I have one table for Vet Visits and one table for Shot Records. The linkage between these tables is Dog Name. On the Dogs layout, I created a portal to Vet Visits to show date of visit and reason of visit. I created another portal on the Dogs layout to Shot records to show shot and next due date (calculated in the Shot record). On the Dogs layout, no data is displayed from either of those 2 tables. Seemed pretty simple to setup, but there must be something simple I am missing. I'm stumped. If someone wants I can send screen shots of the questioned fields, definitions and relationships. Thanks.

I have a table Dogs, with one entry for each dog. I have one table for Vet Visits and one table for Shot Records. These 2 tables have a lookup for dog name in the Dog table. As far as I can see when I compare these 2 tables things look the same. The problem is, for the Vet Visits, on the dog name field, the list of dog names pops up as I wish, BUT on entering data in the Shot Records, the dog names will NOT pop up. I'm stumped. If someone wants I can send screen shots of the questioned fields, definitions and relationships. Thanks.