hi all,
I can't seem to find any topics related to my prob, be it here or Google
so here i am asking you all for help!
I have a main form built on a table named "tblStockItems" and a subform built on a query named "qry" which is based on tblUsedIn. The main form shows each item in tabular format. The subform is supposed to show in datasheet view the subcomponent of the items on the main form if applicable(meaning if the item on the main form doesnt have subcomponent then subform shows nothing)
The problem arises as i cant link the subform to the mainform. Reason being there is no link field between the 2 tables. They are related by a field with Yes?No data type( value 0 or -1).
Could anyone enlighten me? or give me some directions to go from here?
Thanks a lot in advance
p/s pls tell me if i need to clarify the matter. looking to hearing from you!!
I can't seem to find any topics related to my prob, be it here or Google

I have a main form built on a table named "tblStockItems" and a subform built on a query named "qry" which is based on tblUsedIn. The main form shows each item in tabular format. The subform is supposed to show in datasheet view the subcomponent of the items on the main form if applicable(meaning if the item on the main form doesnt have subcomponent then subform shows nothing)
The problem arises as i cant link the subform to the mainform. Reason being there is no link field between the 2 tables. They are related by a field with Yes?No data type( value 0 or -1).
Could anyone enlighten me? or give me some directions to go from here?
Thanks a lot in advance

p/s pls tell me if i need to clarify the matter. looking to hearing from you!!