D
dp
hi guys,
I have a sub table that I wish to store employees that relate to either an
invoice or credit memo table. Both invoice and credit memo tables have
autonumber fields and I realize that on my form/ subform that may be
autonumbers from invoice and credit memo that are the same. So, I wanted to
create another field in the employees table that would separate the invoices
from credit memos. So, I put another field that would act as a 2nd foreign
key
Now on my form, subform for invoice lets say i have specified 2 link fields:
Child: Invoice_IDKEY;TempID
Master TxnID;TempID
The 2 key fields get stored in the emp form, however when I go back to that
invoice # they dont link up. I checked the emp tables and the correct
values are being set. Is there something I am missing?
thanks david
I have a sub table that I wish to store employees that relate to either an
invoice or credit memo table. Both invoice and credit memo tables have
autonumber fields and I realize that on my form/ subform that may be
autonumbers from invoice and credit memo that are the same. So, I wanted to
create another field in the employees table that would separate the invoices
from credit memos. So, I put another field that would act as a 2nd foreign
key
Now on my form, subform for invoice lets say i have specified 2 link fields:
Child: Invoice_IDKEY;TempID
Master TxnID;TempID
The 2 key fields get stored in the emp form, however when I go back to that
invoice # they dont link up. I checked the emp tables and the correct
values are being set. Is there something I am missing?
thanks david