**Poster's Edit 10/11/2016 8:45 a.m. - the new, correct database has been uploaded to the post. Pardon any inconvenience. I would appreciate any help.**
**Poster's Edit: Pardon the error, but I have uploaded the wrong database. I have removed the attachment and will need to upload the correct one tomorrow.**
I'm using Access 2013 and am trying to create a database that houses info from two large spreadsheets, the Schedule and the Design spreadsheets. They track the schedule of what nodes are being segmented and when, along with the design of those nodes, i.e., the transmitter and receiver settings, etc. (for the telecommunications industry).
I've never created a db from the ground up and I am having a lot of trouble with creating the database so that I can update my data in my form and also add new records via my form.
I've created a form and added a tab control where I'm going to put the fields from the Schedule on the 1st tab, called 'Schedule', and about 8 fields from the Schedule on the 2nd tab, called 'Design', along with all of the fields from the Design table.
I'm just working on the Schedule tab right now and have added the fields from the Schedule to the 1st tab on the form. I can update the existing data, but:
1) I can't a new record and my junction table be updated. I just get 0's for all of my fields. Do I have to manually update those each time I need to add a record?
2) Also, all of my fields except the NodeA and NodeB need to be drop down menus. I tried adding the Design Status field as a drop using the Combo Box dialog box. I chose:
a) to get the values from the another table, the Design Status table.
b) the selected fields are the DesignStatusID and the DesignStatus fields
c) sorted by the DesignStatusID field
d) kept the key column (primary key) hidden
e) remember the value for later use (I didn't know what to choose here)
I then went to properties and made the Control Source to be the DesignID, but now when I try to add a new record and select a value in that combo box, it said 'Cannot Add Records, Join key of table 'tblJunction' not in recordset'. I added the DesignStatusID field from the Junction table to the form and hid it so that it doesn't show. How do I fix this?
I've attached my test db, but also here is my form in design view (the Design Status text box and combo box are side by side just as a test).
(The link seems broken, so here's an alternative): https(colon)//drive.google.com/open?id=0B9IyKJSJ52ghcklFUF9PMFYzLWc)
The properties for the Design Status combo box are Control Source: DesignStatusID and Row Source is:
SELECT tblDesignStatus.DesignStatusID, tblDesignStatus.DesignStatus
FROM tblDesignStatus
ORDER BY tblDesignStatus.[DesignStatusID];
Here are my relationships in the Test db I've created, many to many relationships. My actual db will have many tables to the right of the Junction table b/c the Schedule has many fields, like Rx Settings, CMTS Type, Date of Activity, Confirmation Number, etc., that need to be normalized.
(The link seems broken, so here's an alternative): https(colon)//drive.google.com/open?id=0B9IyKJSJ52ghTUNJeElsV2FGdXc)
Thank you in advance for help.
**Poster's Edit: Pardon the error, but I have uploaded the wrong database. I have removed the attachment and will need to upload the correct one tomorrow.**
I'm using Access 2013 and am trying to create a database that houses info from two large spreadsheets, the Schedule and the Design spreadsheets. They track the schedule of what nodes are being segmented and when, along with the design of those nodes, i.e., the transmitter and receiver settings, etc. (for the telecommunications industry).
I've never created a db from the ground up and I am having a lot of trouble with creating the database so that I can update my data in my form and also add new records via my form.
I've created a form and added a tab control where I'm going to put the fields from the Schedule on the 1st tab, called 'Schedule', and about 8 fields from the Schedule on the 2nd tab, called 'Design', along with all of the fields from the Design table.
I'm just working on the Schedule tab right now and have added the fields from the Schedule to the 1st tab on the form. I can update the existing data, but:
1) I can't a new record and my junction table be updated. I just get 0's for all of my fields. Do I have to manually update those each time I need to add a record?
2) Also, all of my fields except the NodeA and NodeB need to be drop down menus. I tried adding the Design Status field as a drop using the Combo Box dialog box. I chose:
a) to get the values from the another table, the Design Status table.
b) the selected fields are the DesignStatusID and the DesignStatus fields
c) sorted by the DesignStatusID field
d) kept the key column (primary key) hidden
e) remember the value for later use (I didn't know what to choose here)
I then went to properties and made the Control Source to be the DesignID, but now when I try to add a new record and select a value in that combo box, it said 'Cannot Add Records, Join key of table 'tblJunction' not in recordset'. I added the DesignStatusID field from the Junction table to the form and hid it so that it doesn't show. How do I fix this?
I've attached my test db, but also here is my form in design view (the Design Status text box and combo box are side by side just as a test).
(The link seems broken, so here's an alternative): https(colon)//drive.google.com/open?id=0B9IyKJSJ52ghcklFUF9PMFYzLWc)
The properties for the Design Status combo box are Control Source: DesignStatusID and Row Source is:
SELECT tblDesignStatus.DesignStatusID, tblDesignStatus.DesignStatus
FROM tblDesignStatus
ORDER BY tblDesignStatus.[DesignStatusID];
Here are my relationships in the Test db I've created, many to many relationships. My actual db will have many tables to the right of the Junction table b/c the Schedule has many fields, like Rx Settings, CMTS Type, Date of Activity, Confirmation Number, etc., that need to be normalized.
(The link seems broken, so here's an alternative): https(colon)//drive.google.com/open?id=0B9IyKJSJ52ghTUNJeElsV2FGdXc)
Thank you in advance for help.
Last edited: