Multiple subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
I checked both things and they are set up the same. Why would only one
subform retain the information and not the other two?
 
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
 
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.
 
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
 
The records show a value in VendorID.

Sprinks said:
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
Click to expand...
 
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
 
That was it! Thank you for your help! :)

Sprinks said:
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
Click to expand...
 
Back
Top