Creating relationships with a value list of entries (not the foreign key)

[CM]

Hi. Apologies in advance for a question which I imagine has been answered several times before: I just couldn't find an answer in a form I understood.

I have two tables - Feeds and Stories. Feeds have many stories, stories have one feed. They are linked by numerical primary and foreign keys. They both have title fields.

In a Story view, I want a popup menu which allows me to select the Feed (by title) which is to be related. I can create a popup menu populated by the Feed title, but I don't know what to do next.

I tried assigning the popup on a Story layout to the related Feed title. This had the effect of overwriting the Feed title.

I created a new field in the Story table which is filled by the Feed title popup. This is inert.

I would like the FeedID foreign key in the Story table to be the one populated by its corresponding FeedID in the Feed table, but all the while showing the Feed title to the user. Is this possible? Or is the solution to have a button next to the inert new field which populated the FieldID accordingly?

Sorry if this sounds complicated. I find reading and writing about database problems to be even more tricky than working with them. ;-)

[bcooney]

I just posted a simple little database that has the value list technique in it that you need see here.

In a nutshell, create a value list of your feeds using the primary feed id and its title. Show only the title.

Set the foreign feed id field in Stories to use this value list and format it to be a popup.

[CM]

Thank you very much. I'll try that out. -)