Hi all,

I'm having trouble figuring out the logic to this problem.  I have a 
table called tblCostCenters with fields "CostCenter" and "WBSelements".  
I have another table called WbsCostCenterMaster.  I want to use this 
table to validate the wbsElements in tblCostCenters.  In other words if 
Cost Center = this, then wbselements must be one of these.  I'm new to 
programming so any advice would be helpful.

Thanks

Malik Al-Amin

Hi Malik, 

Good day.

Check your table relationship. You may find some useful hints by putting 
proper relationship to your tables.

Thanks,
Maha

> Hi all,

> I'm having trouble figuring out the logic to this problem.  I have a 
t> able called tblCostCenters with fields "CostCenter" and "WBSelements".  
I>  have another table called WbsCostCenterMaster.  I want to use this 
t> able to validate the wbsElements in tblCostCenters.  In other words if 
C> ost Center = this, then wbselements must be one of these.  I'm new to 
p> rogramming so any advice would be helpful.

> Thanks

> Malik Al-Amin

How are your users selecting the value that you want to validate?

if you use a combo box then you can set the relevant table as the data
source then set "limit to list" to yes.

No need to delve into code for this just use the wizard to create the combo
box then look at its properties.





Regards

Richard Gibson
IT Manager


The information in this message is confidential and intended for the
addressee only.  If you have received this message in error please delete
and notify the sender, any other action may be unlawful.

The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.


-----Original Message-----
From: Maha Arupputhan Pappan [mailto:mahap@p...]
Sent: 21 May 2002 12:54
To: Access
Subject: [access] Re: Opening a table in Code.


Hi Malik, 

Good day.

Check your table relationship. You may find some useful hints by putting 
proper relationship to your tables.

Thanks,
Maha

> Hi all,

> I'm having trouble figuring out the logic to this problem.  I have a 
t> able called tblCostCenters with fields "CostCenter" and "WBSelements".  
I>  have another table called WbsCostCenterMaster.  I want to use this 
t> able to validate the wbsElements in tblCostCenters.  In other words if 
C> ost Center = this, then wbselements must be one of these.  I'm new to 
p> rogramming so any advice would be helpful.

> Thanks

> Malik Al-Amin