T
THANX LW
Hi there,
I am designing a ledger accounts database. I have a main form
which stores account information e.g Account Number, order Number, Order
Amount (taken from some account). Againts each order # I can have more than
one invoice for which i have a subform in a datasheet view. Since order
number is always unique that is PK in a main form table and subform is
related to main form through Order Number....The dilemma which i am facing is
that my user want to post some transaction directly againt the Account which
might not have any order number....and that i dont understand how to setup
since Account number can be repeated more than once for different order no's
i can't make it a pk...so i need help with how to make a subform in a
datasheet view to keep track of transaction against account # and how to
tackle the scenerio where Order number might be blank.
Sorry my explanation might be vague but please ask any questiion to make it
clear...i really appreciate any help that i can get.
Thanx Alot..
I am designing a ledger accounts database. I have a main form
which stores account information e.g Account Number, order Number, Order
Amount (taken from some account). Againts each order # I can have more than
one invoice for which i have a subform in a datasheet view. Since order
number is always unique that is PK in a main form table and subform is
related to main form through Order Number....The dilemma which i am facing is
that my user want to post some transaction directly againt the Account which
might not have any order number....and that i dont understand how to setup
since Account number can be repeated more than once for different order no's
i can't make it a pk...so i need help with how to make a subform in a
datasheet view to keep track of transaction against account # and how to
tackle the scenerio where Order number might be blank.
Sorry my explanation might be vague but please ask any questiion to make it
clear...i really appreciate any help that i can get.
Thanx Alot..