i have 4 tables(tb1,tb2,tb3,tb4) all contains data parts of certificates.tb1&tb4 are common for all certificates but tb2&3 are optional according to the input data.
all these tables are related by feild "cert no." a record of cert no. say 100, will be having its corresponding record in tb4 & either in tb2 or in tb3.(these all tables also have feild "cert no.")
i have a common report to print the data from all these tables.i designed a form with 2 text box and a command button for print command.
if i enter cert no. say 100 in 1st box and 200 in other when i click button it should print all the 100 records with all the corresponding feild data from all tables where cert no. starts from 100 up to 200,
how is this possible?