Find a way to build combo box for tables


Discuss the below:

Q: Find a way to build combo box for several tables. In a nutshell, I have three major categories (W. Loaders, T. Loaders, Excavators) and for each one there is a three entries of data for example:

W. Loaders .
Model Capacity Cycle Time
D25D 4 .21
D30D 5 .22
D56D 7 .20
D66D 12 .18

W Loaders

Track Loader
Excavators and Shovels
Weel Loader Model Bucket Capacity  Cycle Time

Track Loader Bucket Capacity Cycle Time
Excavators and Shovels Bucket Capacity Cycle Time
902 0.87 0

933C 1.1 0.1583333
307B 0.37 0.22
906 1.05 0

939C 1.25 0.1816667
311B 0.59 0.21
908 1.3 0

953C 1.9 0.1616667
312B 0.68 0.21
914G 1.8 0

963C 2.6 0.1266667
315B 0.68 0.21
924G 2.7 0

973C 3.16 0.1483333
317B 0.68 0.21
928G 2.9 0





318B 1.05 0.25
938G 3.5 0





320B 1.05 0.23
950G 4 0





322B 1.31 0.25
962G 4.25 0





325B 1.44 0.25
966G 5 0





330B 1.83 0.27
972G 5.5 0





365B 2.5 0.3
980G 6 0





375 3.66 0.34
988G 8 0








990 12 0








992G 15 0








994D 21 0








Solution Preview :

Prepared by a verified Expert
Database Management System: Find a way to build combo box for tables
Reference No:- TGS01932881

Now Priced at $20 (50% Discount)

Recommended (99%)

Rated (4.3/5)