p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Please Help...


Message #1 by "George Oro" <george@c...> on Tue, 4 Jun 2002 12:05:57 +0400
Hi Guys,

I have this following tables and scenarios:

c21tblCategory			p22tblProduct
=======================================================
c21CategoryID (Auto)<-------->p22CategoryID (Number)
c21Category				p22ProductID (Auto)
					p22Product


o23tblOrder					o24tblOrderDetails
========================================================
o23OrderID (Auto)<----------------->o24OrderID (Number)
o23ClientID (Linked to tblClient)	o24OrderDetailsID
						o24CategoryID
						o24ProductID
						o24Cost
Sample Data (c21tblCategory)
c21CategoryID	c21Category
1			Category A
2			Category B
3			Category C

Sample Data: (p22tblProduct)
p22Category			p22ProductID	p22Product
1				123			Product A
1				246			Product B
2				369			Product C
3				540			Product D

========================================================
ORDER MAIN FORM
===Linked with OrderID==================================
ORDER SUB FORM

o24CategoryID	o24ProductID				o24Cost
--------------------------------------------------------------
Combo Box (*)	Combo Box (**)				Number
Note:
(*) AfterUpdate o24ProductID.Refresh ' To filter the product under the selected category.
(**) o24CategoryID=o24CategoryID

Sample Entry on the Sub Form (Order Details)=Bound Column is 1 (ID).
Category A		I choose Product A 			0.00
Category A		I choose Product B 			0.00

The problem is, if I will select another Category e.g. B on my next row or entry, the value of the Product A/B that I choose will
gone. But in the table the ProductID is there. Then if I choose Category A again on my next entry, Product A/B will view again but
Product under Category B will gone, but in the Table (o24tblOrderDetails) all the entry (ID) is there.

I'm banging my head now, please help guys...

Cheers,
George





Message #2 by wesley.fitzpatrick@s... on Tue, 4 Jun 2002 10:08:48 +0200
have you checked to see if you have data entry option selected on the form?
If you do it enters the detail into the table and then when your control is
refreshed it would remove it from the form which is set for data entry.

Wes.

----- 
Wesley Fitzpatrick
IS Helpdesk
Syngenta Agro AG

Chemiestrasse 1, Dielsdorf, CH-8157, Switzerland

Tel: +41 (0)1 8558 411

Fax: +41 (0)1 8558 708

wesley.fitzpatrick@s... <mailto:wesley.Fitzpatrick@s...> 


 ~-----Original Message-----
 ~From: George Oro [mailto:george@c...]
 ~Sent: Dienstag, 4. Juni 2002 10:06
 ~To: Access
 ~Subject: [access] Please Help...
 ~
 ~
 ~Hi Guys,
 ~
 ~I have this following tables and scenarios:
 ~
 ~c21tblCategory			p22tblProduct
 ~=======================================================
 ~c21CategoryID (Auto)<-------->p22CategoryID (Number)
 ~c21Category				p22ProductID (Auto)
 ~					p22Product
 ~
 ~
 ~o23tblOrder					o24tblOrderDetails
 ~========================================================
 ~o23OrderID (Auto)<----------------->o24OrderID (Number)
 ~o23ClientID (Linked to tblClient)	o24OrderDetailsID
 ~						o24CategoryID
 ~						o24ProductID
 ~						o24Cost
 ~Sample Data (c21tblCategory)
 ~c21CategoryID	c21Category
 ~1			Category A
 ~2			Category B
 ~3			Category C
 ~
 ~Sample Data: (p22tblProduct)
 ~p22Category			p22ProductID	p22Product
 ~1				123			Product A
 ~1				246			Product B
 ~2				369			Product C
 ~3				540			Product D
 ~
 ~========================================================
 ~ORDER MAIN FORM
 ~===Linked with OrderID==================================
 ~ORDER SUB FORM
 ~
 ~o24CategoryID	o24ProductID				o24Cost
 ~--------------------------------------------------------------
 ~Combo Box (*)	Combo Box (**)				Number
 ~Note:
 ~(*) AfterUpdate o24ProductID.Refresh ' To filter the product 
 ~under the selected category.
 ~(**) o24CategoryID=o24CategoryID
 ~
 ~Sample Entry on the Sub Form (Order Details)=Bound Column is 1 (ID).
 ~Category A		I choose Product A 			0.00
 ~Category A		I choose Product B 			0.00
 ~
 ~The problem is, if I will select another Category e.g. B on 
 ~my next row or entry, the value of the Product A/B that I choose will
 ~gone. But in the table the ProductID is there. Then if I 
 ~choose Category A again on my next entry, Product A/B will 
 ~view again but
 ~Product under Category B will gone, but in the Table 
 ~(o24tblOrderDetails) all the entry (ID) is there.
 ~
 ~I'm banging my head now, please help guys...
 ~
 ~Cheers,
 ~George
 ~
 ~
 ~
 ~
 ~
 ~
 ~
Message #3 by "John Ruff" <papparuff@c...> on Tue, 4 Jun 2002 01:20:14 -0700
George,

It would be easier if you could compact, then zip your db and send it to
me.  I'll check it out for you and let you know what I've got. 


John Ruff - The Eternal Optimist :-)
Always Looking for a Contract Opportunity

xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498 



-----Original Message-----
From: George Oro [mailto:george@c...] 
Sent: Tuesday, June 04, 2002 1:06 AM
To: Access
Subject: [access] Please Help...


Hi Guys,

I have this following tables and scenarios:

c21tblCategory			p22tblProduct
=======================================================
c21CategoryID (Auto)<-------->p22CategoryID (Number)
c21Category				p22ProductID (Auto)
					p22Product


o23tblOrder					o24tblOrderDetails
========================================================
o23OrderID (Auto)<----------------->o24OrderID (Number)
o23ClientID (Linked to tblClient)	o24OrderDetailsID
						o24CategoryID
						o24ProductID
						o24Cost
Sample Data (c21tblCategory)
c21CategoryID	c21Category
1			Category A
2			Category B
3			Category C

Sample Data: (p22tblProduct)
p22Category			p22ProductID	p22Product
1				123			Product A
1				246			Product B
2				369			Product C
3				540			Product D

========================================================
ORDER MAIN FORM
===Linked with OrderID==================================
ORDER SUB FORM

o24CategoryID	o24ProductID				o24Cost
--------------------------------------------------------------
Combo Box (*)	Combo Box (**)				Number
Note:
(*) AfterUpdate o24ProductID.Refresh ' To filter the product under the
selected category.
(**) o24CategoryID=o24CategoryID

Sample Entry on the Sub Form (Order Details)=Bound Column is 1 (ID).
Category A		I choose Product A 			0.00
Category A		I choose Product B 			0.00

The problem is, if I will select another Category e.g. B on my next row
or entry, the value of the Product A/B that I choose will gone. But in
the table the ProductID is there. Then if I choose Category A again on
my next entry, Product A/B will view again but Product under Category B
will gone, but in the Table (o24tblOrderDetails) all the entry (ID) is
there.

I'm banging my head now, please help guys...

Cheers,
George








  Return to Index