Ok... maybe I can explain my question.
My database as some of you will know is not normalized and I do not plan to fully normalize it due to it working perfectly as of now.
however today I added a couple more tables that I believe could be an effort in some normalization.
Start with one of my data entry forms (frm_newpartinput). This form is for adding Part number records to the database.
The form record source is the table (tbl_parts).
The first field (txt box number field) is called "PartNumber" (control source PartNumber field in tbl_parts) allows to put in a part number.
The second field (combobox) is called "Category" (control source Category field in tbl_parts) and has a query to populate choices from the parts table (tbl_categories) formerly was an embedded value list and tbl_categories didn't exist.
The third field (combobox) is called "Vendor" (control source Vendor field in tbl_parts) and has a query to populate choices from the vendor table (tbl_vendors) formerly was an embedded value list and tbl_vendors didn't exist.
There are a couple other fields but not the purpose of this question.
So... there are no relationships between tbl_parts, tbl_categories, or tbl_vendors. This is all done with queries.
Is this a bad way of doing this since it is just a data entry form?
My database as some of you will know is not normalized and I do not plan to fully normalize it due to it working perfectly as of now.
however today I added a couple more tables that I believe could be an effort in some normalization.
Start with one of my data entry forms (frm_newpartinput). This form is for adding Part number records to the database.
The form record source is the table (tbl_parts).
The first field (txt box number field) is called "PartNumber" (control source PartNumber field in tbl_parts) allows to put in a part number.
The second field (combobox) is called "Category" (control source Category field in tbl_parts) and has a query to populate choices from the parts table (tbl_categories) formerly was an embedded value list and tbl_categories didn't exist.
The third field (combobox) is called "Vendor" (control source Vendor field in tbl_parts) and has a query to populate choices from the vendor table (tbl_vendors) formerly was an embedded value list and tbl_vendors didn't exist.
There are a couple other fields but not the purpose of this question.
So... there are no relationships between tbl_parts, tbl_categories, or tbl_vendors. This is all done with queries.
Is this a bad way of doing this since it is just a data entry form?