entry problem

[ngeng4]

i have a combo box that be link to another form to be fill in if new record been entered. but if theres no record, i will receive the error msg,"the microsoft jet database engine cannot find a record in the table "Sub Detail" with key matching fields. here i attach my db

 

[SOS]

Which form is the combo box on?

 

[SOS]

Boy you sure have some normalization issues you need to fix too. You should not have repeating fields (like in the product detail table - you should not have Product1, Product2, Product3, etc).

 

[ngeng4]

if i dont have that kind of table, then how can i do that? i mean, i have 6 products. or u mean, 1 for each?

 

[ngeng4]

i mean, can u help me with this? i have 6 products maximum for each project. how can i create a table for thaT?

 

[SOS]

You would need to set it up like this.

tblProducts
ProductID - Autonumber(PK)
ProductDescription - Text

tblProjects
ProjectID - Autonumber(PK)
ProjectTitle - Text
...etc.

xrefProjectProducts
ProjectProductsID - Autonumber (PK)
ProjectID - Long Integer (FK)
ProductID - Long Integer (FK)


And using that junction table (xrefProjectProducts) you would add products to that project.

You may want to read up on NORMALIZATION.

 

[ngeng4]

ok now ive done what u r saying. but another problem is, why i cant build a form? i made a form by 4 tables. but the form does not appear in a form vie. why is that?

 

[ngeng4]

ok i want my form to be look like this