Data Entry for Current Table Field with Lookup from Another Table
I am working in Filemaker Pro 11 on a dog licensing database. I have several links between tables for various "ID"s. I have a street id in the owners table that links to the streets table by the street id. When I am adding a new owner, I would like to display a list of the street names from the street table for the user to choose from, and then populate the street id in the owner table with the street id from the street table.
Same concept for the breed id and color id into the registration table.
Any suggestions are appreciated. Thank you.