running a Query

[srpatel]

Hello All

Hope fully some one can help on this query i would like to run:

I have a table with the following fields:

tblFormFieldProperties

FormFieldEnableID PK
EllipseAssetTypeID (cbo)
FormFieldID (cbo)
Enabled CheckBox

Taking an example

EllipseAssetID contains records such as Chimney and each EllipseAssetID can be assigned to different FormFields. There are about 24 different formFields. Both EllipseAssetID and and FormFieldID have drop downs as they are related to other tables. So users have to choose from the drop down.

SO E.g. the tblFormFieldProperties would look like

FormFieldEnableID EllipseAssetTypeID FormFieldID Enabled
1 Chimney Diameter Checked
2 Chimney BuildingNo Checked
3 Chimney roomNo Uncheck

I would like to run a query that enables the checkboxes for all the chimney FormFields. Is that possible?

Also how can I construct a query to add new records to the table and have them enabled for all formfields?

Any Help would be appreciated!
Many Thanks!
srpatel

 

[PHV]

a query that enables the checkboxes for all the chimney
UPDATE tblFormFieldProperties
SET Enabled = True
WHERE EllipseAssetTypeID = IDofChimney

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[srpatel]

Hi PH,

Thanks for that! It worked perfect!

srp!