<div>
Thanks. Im sure you are right. I thought that in a one to many relationship the pk of the one ended up as the fk of the many., thus creating the link. Ive obviously got a bit mixed upi and will try reorganising my relationships. Thanks
</div>


Thanks. Im sure you are right. I thought that in a one to many relationship the pk of the one ended up as the fk of the many., thus creating the link. Ive obviously got a bit mixed upi and will try reorganising my relationships. Thanks

<div>
It does ... if your Referrals is the &quot;one&quot; and the YoungPerson is the &quot;Many&quot;, you'd store the value of Referrals.IDField in YoungPerson.YourForeignKey<wbr />Field
</div>


It does ... if your Referrals is the "one" and the YoungPerson is the "Many", you'd store the value of Referrals.IDField in YoungPerson.YourForeignKeyField

<div>
<div class="content wysiwyg-content">
Hello. I get the above message when I try to enter data into a sub form. The main form 'Referral' is based on a table with the same name and the subform 'youngperson' is also based on a table with that name. the relationship of young person to referral is one to many.If i enter some data into the referral table first and then try to enter data into the subform , i get the message 'you cannot add or change ....because a related record is required in young person'<br />
What am I doing wrong ?<br />
Thanks in advance. 
</div>
</div>


Hello. I get the above message when I try to enter data into a sub form. The main form 'Referral' is based on a table with the same name and the subform 'youngperson' is also based on a table with that name. the relationship of young person to referral is one to many.If i enter some data into the referral table first and then try to enter data into the subform , i get the message 'you cannot add or change ....because a related record is required in young person'
What am I doing wrong ?
Thanks in advance. 

'You cannot assign a value to this object'

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.