Prev: PLEASE HELP: Display results in footer section of a split form
Next: How to show what record number you are on in form?
From: Avid Fan on 26 Mar 2010 20:48
On 27/03/2010 6:18 AM, John W. Vinson wrote:
> On Sat, 27 Mar 2010 05:44:44 +1100, Avid Fan<me(a)privacy.net> wrote:
>
>> I have set a relationship between the master and child tables.
>>
>> Customer.ID -> callnotes.Customer_ID
>>
>> Enforce referential integrity.
>> Cascade updates.
>>
>>
>> I am told Access is supposed to put the customer.ID value in the
>> callnotes.Customer_ID it is not working
>
> WHat happens when you enter data into the note field?
>
> I have NEVER ONCE seen a master/child link field fail. I think your
> expectation is what is faulty: just having the relationship or having the
> master/child links will NOT automagically create a new empty record in the
> callnotes table. It will only be created when you *actually enter data onto
> the subform* - are you?

I fill data into the memo text box. I change the one other control left
combobox

I even have a save record and move to next record buttons on the forms

I have placed a text box control linked to customer_id the only way I
can get the record to save is by placing a valid ID number in the field.
From: Avid Fan on 26 Mar 2010 21:50
On 27/03/2010 6:12 AM, Dirk Goldgar wrote:
> "Avid Fan" <me(a)privacy.net> wrote in message
> news:%236Q8lRRzKHA.3884(a)TK2MSFTNGP06.phx.gbl...
>> I have set a relationship between the master and child tables.
>>
>> Customer.ID -> callnotes.Customer_ID
>>
>> Enforce referential integrity.
>> Cascade updates.
>>
>>
>> I am told Access is supposed to put the customer.ID value in the
>> callnotes.Customer_ID it is not working
>>
>>
>> How do I do it manually in VBA code?
>
>
> You don't. This is controlled by the Link Master Fields and Link Child
> Fields properties of the subform control. If you created that
> relationship after you added the subform to the main form, Access would
> not have been able to guess that those were the linking fields, so you
> have to go to the properties of the subform control -- the control on
> the main form that displays the subform -- and enter "ID" in the Link
> Master Fields property and "Customer_ID" in the Link Child Fields
> property (without quotes around the field names).
>

That was it!!!!!!!!!

For some reason the customer.id was linked to callnotes.id not
callnotes.customer_id.


BIG THANK YOU!!!!!!
From: Avid Fan on 26 Mar 2010 22:06
On 27/03/2010 12:31 PM, John W. Vinson wrote:
> On Sat, 27 Mar 2010 11:48:32 +1100, Avid Fan<me(a)privacy.net> wrote:
>
>> I fill data into the memo text box. I change the one other control left
>> combobox
>>
>> I even have a save record and move to next record buttons on the forms
>>
>> I have placed a text box control linked to customer_id the only way I
>> can get the record to save is by placing a valid ID number in the field.
>
> And this is in fact a Subform in a subform control (not a popup form launched
> from code)?
>
> Please post the SQL view of the mainform and the subform's Recorsource
> properties and (again) the Master Link Field and Child Link Field properties
> of the Subform. Something is very very odd here.

The error was in the Master Link Child link property of the subform.
for some reason they were linked to customer.Id callnotes.ID instead
of callnotes.customer_ID

It was an "ID ten IT " error (ID10T)
 | 
Pages: 1
Prev: PLEASE HELP: Display results in footer section of a split form
Next: How to show what record number you are on in form?