USING A PORTAL FOR MULTPLE RECORD CREATION?
I have a database in which i have 3 tables. The main table is for the creation of hoses "HOZTRAK" the next is for the creation of test reports for hoses,"HOZ REPORTS", it has mainly imported data for "HOZTRAK" but needs to be kept seperate. Finally is the table "HOZ REPORT HISTORY"
There has been a new database created every year for "HOZTRAK", which is silly and im trying to import all the records of the databases into one.However in these databases over the years people have duplicated the hoses serial number to create new test report records. So now there is roughly 2 serial numbers the same in every database depending on the year of their last test. A mess.
What i would like to do is a table which contains the hoses' history, cradle to grave if you like, and also in affect to be able to see all the years the hose has been tested. At the moment there are database from 1999. So if you want to see if they were tested in that year....Search all the databses....
I though maybe a portal? from test reports to history one to many relationship?