Sample Query Result.
Reg | Make | Model | Owner | Engines
ZS-ZZZ | Boeing | 777-344 | South African Airways | x2 GE90TR |
ZS-YYY | Airbus | 380-800 | South African Airways | X4 PW100ER |

On the table side,
*REG table would look like
Country | Reg| make |model | BoeingID | c/n | l/n | m/s/n | owner | # of
engines | Engine Make| Engine Model |
ZS | ZZZ | B | 773 | 44 | 32435 | 709 | 73406 | SAA | 2 | GE | 90TR
ZS | YYY | A | 388 | __ | 1435 | 179 | ___ | SAA | 4 | PW | 110ER
...

Now the fields above would collect the info from table below like .....
*Country
Code | FullName
ZS | South Africa
ZU | South Africa
Z | Zimbabwe
....

*Make
Code | ManuFullName
A | Airbus
B | Boeing
....

*Model (this table would check the above table)
make | abbrevation | fullproductname
A | 388 | A380-800
B | 772 | 777-200
B | 773 | 777-300
....

*BoeingCode (this field would only apply if it is B product)
Code | AirlinerName
44 | SAA
.....

*Owner | FullOwnerdetails (this field would have all airline details and a
link 4 all current airline aircraft on reg.
SAA | South African Airways
......

Now I have back code to edit any of these table I need the front page code
for the results page:
Sample Query Result.
Reg | Make | Model | Owner | Engines
ZS-ZZZ | Boeing | 777-344 | South African Airways | x2 GE90TR |
ZS-YYY | Airbus | 380-800 | South African Airways | X4 PW100ER |

And the Query Page, which checks all fields and/or certain flieds check the
tables and builds up the solution result page.

Now when the person clicks on Boeing that will list all boeing aircraft, the
same will happen if he click 777 then all the 777 are listed.
When he clicks SAA it will list all SAA aircraft plus it will give links to
SAA company profile, pass aircraft list, on order list.

So baiscly any table can be searched and the result is given like above plus
more in some (not all cases).

So if you can solve this monster please help me.