I have a two tables - One is Prospecting and the other is Call Log which tracks the result of prospective calls
The Table for Prospecting has Indexes with Unique values such as phone number and street and Stores the Prospect info
The Form for Prospecting contains a subform of Call Log
The problem is when I want to update the Call Log Subform, an error is displayed for the Mainform Prospecting because it is seeing the same data on the mainform as what is in the table so it thinks the data is duplicated and wont let me save the Main form or the subform.
How do I create a new record in the subform without Access thinking the data in the parent form is duplicated?
I just want to update call results for the prospect. I tried Setting DataEntry to Yes but obviously I get a blank Parent form and blank subform.
How are the Child subform related to the Parent Main form
did you use the
Link Master Fields
Link Child Fields
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
To be honest I am not that experienced and have tried using the Master and Child field linkage in design view but have always had trouble understanding how to do it. Could you give me an example by any chance...The bit I don't understand is which fields to link and how to determine which would be a master field and which would be a child field. In other words, do both tables need to have the same fields -
ID;ID and Prospect Last;Prospect Last??