Hi,
Parent field is a unique reference number [refnum].
Child records begin with, and are linking properly with [refnum] field. Child records include a field [InvoiceNum]. Grandchild records will be linked by, [invoicenum] field. [invoicenum] field is required to be labelled by the person entering data as 1, 2, 3, etc... and not the actual number printed on the invoice. Therefore, [invoicenum] will not be unique for the grandchild. Unfortunately I cannot alter that as it is "industry standard" in my profession and the users will become confused if I change it. I continue...
Grandchild records begin with, and do not link properly with, [invoicenum] field because of the non-unique key.
I enter into record 2 on the set form parent a unique reference number, then when I enter "1" in the child browse it shows all the data from Parent record "1", Invoice "1" in the grandchild browse because of the non-unique link in the set.
I have considered adding a field such as [ActualInvoiceNum] to create a more unique key, but the possibility still exists for two companies using the same actual invoice number, and it is unnecessary data entry I think based on the following. I cannot really (in my opinion) alter the design of the set as the parent record has many other one-to-one fields for that unique key, and the child has other one-to-one fields for that invoicenum key.
I tried to FILTER the GRANDCHILD records in the set to only include the current (unique) reference number in the parent, but have since failed miserably. I also tried to move the grandchild in the set to become a child, and include the unique reference number as the link and try to filter but failed there also. I am confident that using an expression I can filter grandchild records to only show the current parent record with that unique identifier, but can't figure out how.
Anyone do this before successfully, or have another idea that might work?
Thanks in advance.
Parent = masterfile.dbf [refnum]
Child = Invoice.dbf [invoicenum]
Grandchild = Lineitems.dbf [linenum]
Parent field is a unique reference number [refnum].
Child records begin with, and are linking properly with [refnum] field. Child records include a field [InvoiceNum]. Grandchild records will be linked by, [invoicenum] field. [invoicenum] field is required to be labelled by the person entering data as 1, 2, 3, etc... and not the actual number printed on the invoice. Therefore, [invoicenum] will not be unique for the grandchild. Unfortunately I cannot alter that as it is "industry standard" in my profession and the users will become confused if I change it. I continue...
Grandchild records begin with, and do not link properly with, [invoicenum] field because of the non-unique key.
I enter into record 2 on the set form parent a unique reference number, then when I enter "1" in the child browse it shows all the data from Parent record "1", Invoice "1" in the grandchild browse because of the non-unique link in the set.
I have considered adding a field such as [ActualInvoiceNum] to create a more unique key, but the possibility still exists for two companies using the same actual invoice number, and it is unnecessary data entry I think based on the following. I cannot really (in my opinion) alter the design of the set as the parent record has many other one-to-one fields for that unique key, and the child has other one-to-one fields for that invoicenum key.
I tried to FILTER the GRANDCHILD records in the set to only include the current (unique) reference number in the parent, but have since failed miserably. I also tried to move the grandchild in the set to become a child, and include the unique reference number as the link and try to filter but failed there also. I am confident that using an expression I can filter grandchild records to only show the current parent record with that unique identifier, but can't figure out how.
Anyone do this before successfully, or have another idea that might work?
Thanks in advance.
Parent = masterfile.dbf [refnum]
Child = Invoice.dbf [invoicenum]
Grandchild = Lineitems.dbf [linenum]
Comment