Hi all im very new to Microsoft access .im intrested its features. So i want some help for following .
My data base
Equipment model part. description drawing no
Crusher. X125. X125001. Xyz. 1234.
X125002. Cvb. 5678
X125003. Zxc. 88890
Crusher. X250. X250001. Xyz2. 76578
X250002. Cvb2. 99087
X250003. Zxc2. 7820
Miner. Y500. Y500001. Abc. 57392
Y500002. Asd. 663427
Y500003. Ghj. 725272
Miner. Y625. Y625001. Abc2. 829202
Y625002. Asd2. 6540
This is the example data base please help me in form that if equipment field if i enter crusher then in model field it should show x125 and X250.if i enter miner means it should show y500 and y625. Then part field depend on model it should show X125001 or X125002. Like that after selection it shoud automatically fill the description field and drawing no field. Then during retrival of any records it should populate model and quipment field according to requirement. Please help me to solve . huge data is there above said only sample
My data base
Equipment model part. description drawing no
Crusher. X125. X125001. Xyz. 1234.
X125002. Cvb. 5678
X125003. Zxc. 88890
Crusher. X250. X250001. Xyz2. 76578
X250002. Cvb2. 99087
X250003. Zxc2. 7820
Miner. Y500. Y500001. Abc. 57392
Y500002. Asd. 663427
Y500003. Ghj. 725272
Miner. Y625. Y625001. Abc2. 829202
Y625002. Asd2. 6540
This is the example data base please help me in form that if equipment field if i enter crusher then in model field it should show x125 and X250.if i enter miner means it should show y500 and y625. Then part field depend on model it should show X125001 or X125002. Like that after selection it shoud automatically fill the description field and drawing no field. Then during retrival of any records it should populate model and quipment field according to requirement. Please help me to solve . huge data is there above said only sample