Skip navigation links

MySQL Forums :: Microsoft Access :: Populating a Foreign Key


Advanced Search

Populating a Foreign Key
Posted by: Phillip Perry ()
Date: July 14, 2010 08:12PM

Hi, I've just downloaded mySQL and this Workbench program for Windows. I'm curious if it's possible to populate foreign keys automatically with a dropdown list of some kind. See, I'm used to working with MS Access so I'm having some transition issues at the moment. Any help would be greatly appreciated. I included an example below...

I have a table named clients, including a column displaying who my web host company is. I want the primary key from the hosts table to go into the hostname column of the clients table. Is there a dropdown solution or do I have to manually input the numbers?

Options: ReplyQuote


Subject Views Written By Posted
Populating a Foreign Key 2066 Phillip Perry 07/14/2010 08:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.