Hello,

I need help in the folllowing
1.I have a welder qualification database as an excel file. The database includes the following columns.
A- Sr no: Serial number from 1,2,3 ... it is unbounded
B- Welder Name: The name of the welder.
C- Welder Stamp Number: It is a unique number given to each welder.
D- Process welded: It is the welding process in which the welder is qualified; namely there are 5 process viz SMAW,GTAW,SAW,GMAW and FCAW.
E- Filler number: The identity of the consumable with which welding is done. These are unique numbers for each consumable. They are number from 1 to 50.

2. Now I need a form to enter this data and keep on updating it.
3. My main purpose is to query this data to find suitable welders for deployment on the job.

4. Here are the rules which are applicable.

I) A welder qualified for a particular process can only be used for welding in that process.
II) A welder qualified for a particular filler number can weld also weld with filler numbers from that decade and the 5 th filler from the previous decade if it exits.

By this I mean if a welder is qualified for filler 45, he can weld with all the fillers in that decade (i.e 41 to 50) and 5th filler from previous decade(i.e. 35).
Hence the output userform will have all welders who are qualified for the pair of input variables(Process and Filler Number).

Is excel the correct programme for doin the same.

Thanks