How can I use the name of a table in a link, as a match from the data in a row in another table, in Crystal Reports 7? The database is ODBC: MySQL
The problem here may well be my database structure. I'm new at SQL, and I know my database could probably be better structrured.
Briefly, I have one table with MAC addresses. I have a lot of other tables, with the MAC address as the table name, and a bunch of data that gets posted to this table every 20 minutes from the device with that MAC address.
Would it be better to lump all the data posts into one table and make an index on MAC address? That table is going to get large: we may have ~500 devices posting up to 9 rows of data every twenty minutes.
The problem here may well be my database structure. I'm new at SQL, and I know my database could probably be better structrured.
Briefly, I have one table with MAC addresses. I have a lot of other tables, with the MAC address as the table name, and a bunch of data that gets posted to this table every 20 minutes from the device with that MAC address.
Would it be better to lump all the data posts into one table and make an index on MAC address? That table is going to get large: we may have ~500 devices posting up to 9 rows of data every twenty minutes.