wackywoo105
Registered User.
- Local time
- Today, 10:11
- Joined
- Mar 14, 2014
- Messages
- 204
I have a database with around 3k entries. I want to create more tables that are linked to records in the main table, but only for some of the 3k main records, not all of them. I also want one of these tables to be capable of multiple records that are linked to a single record in the main table.
Currently I have created the first separate table (which only requires a single record per main table record). For this table I use the unique ID in the main table in the 2nd field of the sub table. The sub table then also has a unique id for each record. Occasionally, if my database glitches, it adds the data from a main table record to the 1st record in the sub table, rather than a new record or the correct one. Due to this I keep the 1st record as a dummy record.
I'm guessing I haven't gone about this in the correct way. Can anyone help with what I am suppose to do, or point me to guide?
Currently I have created the first separate table (which only requires a single record per main table record). For this table I use the unique ID in the main table in the 2nd field of the sub table. The sub table then also has a unique id for each record. Occasionally, if my database glitches, it adds the data from a main table record to the 1st record in the sub table, rather than a new record or the correct one. Due to this I keep the 1st record as a dummy record.
I'm guessing I haven't gone about this in the correct way. Can anyone help with what I am suppose to do, or point me to guide?
