In my database, I have 3 tables, Tradename, TradenameRelationCompany and Company. The Company table consists of a list of Companies and their information. The Tradename table consists of all the Tradenames that are available. And finally, the TradenameRelationCompany consists of Relationship between the Tradename and the Company.
I am using Visual Basic to make the database run. So the idea is that when program runs, and u click on Tradename A, Company A information comes out. And if u click on Tradename B, Company B information comes out, etc.
The thing is that some of the information of the company is the same because they are the same company but their description of their products are different. Get what I mean? Hence my problem is, for example, Company ABC has 2 Tradenames. So when u click on Tradename 1, Company ABC description of the 1st one comes out. But when u click on Tradename 2, Company ABC description of the 1st also comes out, instead of the 2nd description that is suppose to come out.
Can anyone help me? I am in desperate help! I am still new to Visual Basic & Access. So if you got any ideas with what is wrong with my program please tell me! Your help is greatly appreciated!
|