By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Autofill the form by checking specific condition in database

P: 1
Dear Members, I want to Autofill one of the field in my form, by checking specific conditions in my database. Example of which is as below:

1. Date of Maintenance :
2. Loom No. :
3. Component Replaced :
4. Component Type :
5. Latest date for same component replacement :

I want to autofill the Sr. No. 5 in the form itself by checking database, and if Sr. No.2=Sr No.3=Sr. 4, then latest date should be autofill in Sr. No. 5

Say, A component was replaced in a Loom on 01/01/2013 & again after six month same component is replaced on 01/06/2013 so while filling up the form, In sr. no. 5 latest date 01/01/2013 of replacement of same component in same loom should be pulled from data base.

Pl. help me...

Thanks in advance
Jan 14 '14 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
You're not being very clear here:

Are you saying that in your database you have a table and in that table is a field named [SR.No] with the values 1, 2, 3,etc..

Or are you saying that in your table there is some field that has these values "Sr No.1", "Sr No.2", "Sr No.3", etc...

Also, please understand, we're here to help not usuall to do; thus, we do need to see what you have already attempted.
Jan 14 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.