Multiple subforms

[Guest]

I have a table (Vendor) with three subforms (Contracts, Contacts, 800#) with
all subforms set up as one to many relationship with VendorID. I enter data
into the first record then go to the next record. When I return to the first
record, it only shows the data in the Contacts subform. What step have I
missed. Please let me know if you need more information to help.

 

[Guest]

Misty,

Check:

- That each subform itself has a valid RecordSource matching the table or
query into which you want entered data stored.
- That each subform (control) has the LinkMasterFields and LinkChildFields
properties set to the matching VendorID field in the main form's RecordSource
and each subform's RecordSource, respectively.

Hope that helps.
Sprinks

 

[Guest]

I checked both things and they are set up the same. Why would only one
subform retain the information and not the other two?

 

[Guest]

Misty,

What does the data itself look like in Table View? Do the records in the
Child tables all have a value in the linking field?

Sprinks

 

[Guest]

Table - Vendor (main form)
VendorID (pk)
VendorName
ProgramName
ProgramDescription
800#ID (fk)
ContactID (fk)
ContractsID (fk)

Table - 800# (subform)
800#ID (pk)
VendorID (fk)
800#
MarketSource
AffiliaionGroup

Table - Contacts (subform)
ContactID (pk)
VendorID (fk)
Name
PhoneNumber
Address

Table - Contracts (subform)
ContractsID (pk)
VendorID (fk)
StartDate
EndDate

Hope this helps answer your question.

 

[Guest]

Misty,

I see that your table *structures* all have a corresponding foreign key. I
was referring, though to the *records* in each child table themselves. If
any of them are missing a value in VendorID, they wouldn't display on your
form, which would indicate that there's something wrong with either the
MasterLinks properties or the RecordSource of the subforms.

Sprinks

 

[Guest]

The records show a value in VendorID.

Misty,

I see that your table *structures* all have a corresponding foreign key. I
was referring, though to the *records* in each child table themselves. If
any of them are missing a value in VendorID, they wouldn't display on your
form, which would indicate that there's something wrong with either the
MasterLinks properties or the RecordSource of the subforms.

Sprinks

 

[Guest]

Aha! If the data is there, it must be getting in, so there's nothing wrong
with the setup of your linking fields. I suspect the subforms that do not
show any data must have their DataEntry property set to Yes.

Hope that helps.

Sprinks

 

[Guest]

That was it! Thank you for your help!

Aha! If the data is there, it must be getting in, so there's nothing wrong
with the setup of your linking fields. I suspect the subforms that do not
show any data must have their DataEntry property set to Yes.

Hope that helps.

Sprinks