Subform does not show details records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan T - 17 May 2007 08:27 GMT

My main form links to Invoice table:
ID
InvoiceNumber
Date
Sales

My subform links to InvoiceItem table:
ID
ItemNumber
Qty
Price
InvoiceID

These are Data tab of the sub-form:
Source Object: frmInvoice
Link Child Fields: InvoiceID
Link Master Fields: ID
Enabled: Yes
Locked: No

So on the main form whatever I navigator my invoices, the subform is always
empty.

Reply to this Message

Maurice - 17 May 2007 08:57 GMT

Alan,

Your tables have identical ID-names. This makes it very hard to distinguish
the two of them. The problem could be that you are referencing the wrong ID.
By making the ID-field name more clear you are excluding a possible reference
problem.

Is the subform connected to the right ID?

Maurice

> My main form links to Invoice table:
> ID
[quoted text clipped - 18 lines]
> So on the main form whatever I navigator my invoices, the subform is always
> empty.

Reply to this Message

Alan T - 17 May 2007 13:16 GMT

Hi,

Yes, the subform is referencing the right ID.
On the Data tab:
Link Child Fields: InvoiceID
Link Master Fields: ID

The InvoiceID is the foreign key in the tblInvoiceItems.
So basically tblInvoiceItems.InvoiceID <--> tblInvoices.ID

> Alan,
>
[quoted text clipped - 33 lines]
>> always
>> empty.

Reply to this Message