Pop up list based on linked tables
I have a database and among the records I want to reference a linked table. When viewing the records, I want the linked database field to present as a popup menu. The records in the popup list should have already been entered from the linked table and others could be added in the future in that second table expanding the popup list. I do not see any way to make a popup list except by using a static list of values. Is there any way to have a dynamic popup list as a data field referencing this other data table?
Thanks again experts!