Hi there.
I just wanted to ask peoples opinion on something.
In the database I'm working on I have to create two new tables that will be joined to the Main table. each of the new tables has only one field (as well as the FK) with a one to many relationship with the Main table as there will up to 4 records per main record. Note, the fields will only be set at 15 text characters.
I'm trying to decide if it's better to only make one table and have the two fields together even though one might have 3 records, another might have 2 records and so on (of course with the same FK), making some blank space in the opposite.
Normally I wouldn't do this, however, it's a table with only two fields.
Or would it be better just to keep the two fields within seperate tables?
Also, I'll be developing a form with the two fields together, linked to the main form (This is also because there isn't enough room within the Main form).
Each will be in datasheet view.
Thanks in advance for any advice.
I just wanted to ask peoples opinion on something.
In the database I'm working on I have to create two new tables that will be joined to the Main table. each of the new tables has only one field (as well as the FK) with a one to many relationship with the Main table as there will up to 4 records per main record. Note, the fields will only be set at 15 text characters.
I'm trying to decide if it's better to only make one table and have the two fields together even though one might have 3 records, another might have 2 records and so on (of course with the same FK), making some blank space in the opposite.
Normally I wouldn't do this, however, it's a table with only two fields.
Or would it be better just to keep the two fields within seperate tables?
Also, I'll be developing a form with the two fields together, linked to the main form (This is also because there isn't enough room within the Main form).
Each will be in datasheet view.
Thanks in advance for any advice.
