Normal Topic Subform with relational linking (Read 397 times)
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Subform with relational linking
Jun 5th, 2005 at 12:59am
Print Post Print Post  
I have an application with an invoice form and a line item form.
I set up the invoice form to have the line item form as a subform with relational linking.
Subrecords using  matching field values (relational)
Show related child records where Invoice_no matches I
Greyed out
Parent  Invoice_no  number
Child     I                  number
Table view

I  exported data from Q&A then imported into another form that containred invoice information which included a variable number of line items and then selectively exported line item information into an ASCII file that was later imported into the line item form. A similar procedure was performed for the invoice data. Thus I have both forms filled with good  data that I hoped would display when I searched the invoice form. It didn't happen. Each form displays the correct information for that form but the invoice form does not show the line items.
Were my expectations incorrect or did I do something wrong? I thought this procedure would match the records
and combine them on the invoice form.
Thanks for any assistance you can give me.

Harley
  
Back to top
 
IP Logged