M
Mercadogs
Hello: I need an expert on this one, please!
The purpose of my database is to store and search information about some of
our company products. The fields contain the different attributes
(information) about these products. I want to create a form(s) that will
allow data entry and update for all these fields. I've tried creating forms
based on both tables and queries, but none were allowing updates. I need some
one to help me on creating updateable queries and check my tables and
constraints(relationships) to see what I'm do wrong.
The fields "CT, DOFL, and FL" combined are the determinants to all the other
fields. All fields (CT, DOFL, FL, IN, SON, SD, OPN, DN, VName, VNumber, KN,
BN,
SN, SB, NS, Notes, FN) are divided into different tables and linked by
relationships. A field is not in two tables unless, it is being used as a
Foreign key(s) and Primary Key. All the relationships are Many-to-one.
I have normalized my tables as follows (I have shortened the field names for
privacy reasons). Where MAIN_TABLE should be the source of all other
information. I think these tables are normalized correctly, but I cannot
create a form or query that will update/add all fields as expected. Please
consider patiently helping with this, I'm pulling out the hairs on my head as
we speak.
------------------------------------------------------------------------------------------------
TABLES AND CONSTRAINTS:
MAIN_TABLE (CT, DOFL, FL) ---> (These three fields determine every other
field in the database)
WHERE MAIN_TABLE.CT must exist in C_T.CT
and
WHERE MAIN_TABLE.FL must exist in S_O_N.FL
K_N (CT, KN) ---->Note: CT and KN are composite keys
WHERE K_N.CT must exist in C_T.CT
B_N (CT, BN) ----> Note: CT and BN are composite keys
WHERE B_N.CT must exist in C_T.CT
C_T (CT, IN, SD, OPN, DN, VName, VNumber, SN, SB, NS, Notes)
Where CT is the primary key --> (and determines every field in table
C_T)
S_O_N (FL, SON)
WHERE S_O_N .SON must exist in F_N.SON
and
where FL is the primary key
F_N (SON, FN)
WHERE SON is the primary key
The purpose of my database is to store and search information about some of
our company products. The fields contain the different attributes
(information) about these products. I want to create a form(s) that will
allow data entry and update for all these fields. I've tried creating forms
based on both tables and queries, but none were allowing updates. I need some
one to help me on creating updateable queries and check my tables and
constraints(relationships) to see what I'm do wrong.
The fields "CT, DOFL, and FL" combined are the determinants to all the other
fields. All fields (CT, DOFL, FL, IN, SON, SD, OPN, DN, VName, VNumber, KN,
BN,
SN, SB, NS, Notes, FN) are divided into different tables and linked by
relationships. A field is not in two tables unless, it is being used as a
Foreign key(s) and Primary Key. All the relationships are Many-to-one.
I have normalized my tables as follows (I have shortened the field names for
privacy reasons). Where MAIN_TABLE should be the source of all other
information. I think these tables are normalized correctly, but I cannot
create a form or query that will update/add all fields as expected. Please
consider patiently helping with this, I'm pulling out the hairs on my head as
we speak.
------------------------------------------------------------------------------------------------
TABLES AND CONSTRAINTS:
MAIN_TABLE (CT, DOFL, FL) ---> (These three fields determine every other
field in the database)
WHERE MAIN_TABLE.CT must exist in C_T.CT
and
WHERE MAIN_TABLE.FL must exist in S_O_N.FL
K_N (CT, KN) ---->Note: CT and KN are composite keys
WHERE K_N.CT must exist in C_T.CT
B_N (CT, BN) ----> Note: CT and BN are composite keys
WHERE B_N.CT must exist in C_T.CT
C_T (CT, IN, SD, OPN, DN, VName, VNumber, SN, SB, NS, Notes)
Where CT is the primary key --> (and determines every field in table
C_T)
S_O_N (FL, SON)
WHERE S_O_N .SON must exist in F_N.SON
and
where FL is the primary key
F_N (SON, FN)
WHERE SON is the primary key