General information
Title:
How to link old tables
I have three old tables, originally developed in different places at different times, which are going to be linked, since they share about three fields. However, apart from those three fields, the other information they contain will probably not be shared much, if at all. One of the tables has several dozen fields and a large child table, one has many more records and a different child table, and the third is small. Given that they will still be used separately, would it be better to keep them as separate tables and relate them one to one, or is it more efficient to put it all in one table? Either way, I suppose I will be selecting the same fields I need to make different views, whether the fields are in one table or three. Reports of data from the two smaller tables will use the two fields from the biggest table, but reports of data from the biggest table will not need any data from the two smaller tables.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only