I have two Tables one relates to Mobile Phone Information & second one relates to Sale Invoice Record.
Mobile Phone Information & Sale Invoice Record Table have relationship of one to many with MobileID.
I dont have expouse of writing codes in VBA.
The problem is that on Sale Invoice Record form. Here we enetered the information about purchased mobile by the customer.
On sale Invoice form. I can access the MobileID in combo. Here all the MobileID(Mobile Phone Information tbl) appears.
But some other Info like ModelNumber & Price how come on the selection of desired MobileID from combo by the User.
(ModelNumber,Price also in the Mobile Information table)
Please guide me what to do & how. Or any example datasebase(link).
It is my own idea that it has to be done with Change Event(combo), You can have more better idea pratically.
Mobile Phone Information & Sale Invoice Record Table have relationship of one to many with MobileID.
I dont have expouse of writing codes in VBA.
The problem is that on Sale Invoice Record form. Here we enetered the information about purchased mobile by the customer.
On sale Invoice form. I can access the MobileID in combo. Here all the MobileID(Mobile Phone Information tbl) appears.
But some other Info like ModelNumber & Price how come on the selection of desired MobileID from combo by the User.
(ModelNumber,Price also in the Mobile Information table)
Please guide me what to do & how. Or any example datasebase(link).
It is my own idea that it has to be done with Change Event(combo), You can have more better idea pratically.
