I have a table called project and which has a field called ProjectName.
ProjectName is a foreign key for a table called Moneypaid in.
The two table have a one to many relationship.
I have developed a form for the "Moneypaidin" table with a combo box for the Foreign key "ProjectName".
However although I can select the projectName in the form -it does not show up in the Moneypaid in table.