doxtor
Posts: 24
|
| Posted: 07/05/2008, 5:26 AM |
|
Hi all..
I need suggestion.
I have 2 table, 1 is to record the company name, and 1 is to records the contacts of the company(because 1 company can have more than 1 contact).
And then I want to make invoice, here I must select the company, and then select the contact based on company I choosed.
I use dependent list box to select the contacts based on company, and one autofill to fill all information. the table scheme is like this :
tblCompany : CompID(pk) int, CompanyName
tblCompanyDetail : CompDetID(pk), CompID, ContactName, Email, Address, Phone, Fax
The problem is, I can not save the company data in table invoice. Is this because I use dependent listbox(which is run when the master slave clicked)?
Any suggestion how to do this?
Thank you so much
|
 |
 |
doxtor
Posts: 24
|
| Posted: 07/05/2008, 7:32 AM |
|
it's resolved. What i do is add hidden text box, and add custom code before show.
If CompDetID have value, the dependent listbox will hidden, and replaced with the text box filled with the company detail data. 
I don't know the other ways, so i just use this.
|
|
|
|
|
