Gramps
16th September 2001, 09:31.59 PM
Why wouldn't the combined two keys of tHORSE and tDATE uniquely identify each row of data? A horse can only race once on one day (it MIGHT be entered in two or more spots, but since it could only race at one of them, it would have to be scratched from the rest), and barring the possibility of two horses with identical first 15 letters, I don't see how duplicates could occur. I don't know if creating multiple keys slows down queries, reports, opening the table, etc., but if it did, I would think that two keys would work faster than four.
I want to make one more more combined tables as well as keep my ALL_MSA and ALL_IMPC tables. I would imagine that after making a Make Table Query for each table, I can change them to Append Queries. Then, I'd have to import ALL_MSAC.txt and ALL_IMPC.txt into their respective ALL_MSA and ALL_IMPC tables, and also import those text files into holding tables, named, say, ALL_MSA_TEMP and ALL_IMPC_TEMP, which would be linked. The append queries could be used to append data from the temporary tables ALL_MSA_TEMP and ALL_IMPC_TEMP to the combined tables, then the temporary tables would be blanked out when finished so that they could be used to import the next day's (or week's) data to and then into the combined tables.
Is there an easier way to do this if I want to keep my ALL_MSA and ALL_IMPC tables? I want to keep these because I don't want to put every unique factor into the combined table, and I may want to change the factors in the table later, which would seem to be easier to do if I had the ALL_MSA and ALL_IMPC tables still up to date.
I want to make one more more combined tables as well as keep my ALL_MSA and ALL_IMPC tables. I would imagine that after making a Make Table Query for each table, I can change them to Append Queries. Then, I'd have to import ALL_MSAC.txt and ALL_IMPC.txt into their respective ALL_MSA and ALL_IMPC tables, and also import those text files into holding tables, named, say, ALL_MSA_TEMP and ALL_IMPC_TEMP, which would be linked. The append queries could be used to append data from the temporary tables ALL_MSA_TEMP and ALL_IMPC_TEMP to the combined tables, then the temporary tables would be blanked out when finished so that they could be used to import the next day's (or week's) data to and then into the combined tables.
Is there an easier way to do this if I want to keep my ALL_MSA and ALL_IMPC tables? I want to keep these because I don't want to put every unique factor into the combined table, and I may want to change the factors in the table later, which would seem to be easier to do if I had the ALL_MSA and ALL_IMPC tables still up to date.