I created a database to house trucking info one customer can have upwards of 100 trucks so I have them broken up into 5 tables and with 25 truck & info on each I'm trying to create a search function that will search the Vins from all 5 tables I've watch nearly all videos but I just can't get it
For reference the table Vehicle1T is make1 model1 vin1,weight1,make2,model2,vin2,weight2 up to 25 then the next table has 26-50 etc I want to Vin search all 5 vehicle1-5T to get the vin of the truck I'm looking for
Kevin Robertson
@Reply 2 years ago
If they are all trucks, why have 5 tables?
Store all the truck information in one table and have related tables for other data.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
