Relationships and Portals
Im having some real trouble working with a relationship and portal...
i have a table that keeps records of my reptiles:
Record_ID - auto serial
Then I have a table that keeps track of different types of Morphs (color and pattern variations):
Morph_ID - auto serial
so one reptile can have one or more different morphs related to it, on the form showing reptile records i would like to show a portal listing the morph(s) relating to that specific reptile.
is there a way to have this listed on the main reptile form? will i need to create another instance of the morphs table? any help is much appreciated!