@drunyan0824
Originally Posted by
drunyan0824
Each column on the excel worksheets contains the various information about the number assigned to the wire, the source, destination and a description of where the wire is connected.
At the bottom of the worksheet are all of the different categories that we use so we don't have to look through all of our audio cable before we find the network cable that we are trying to find.
That is why I was thinking I would only need two tables.
That is a good starting point. You are not starting out "committing spreadsheet" - a good thing. "Committing Spreadsheet" means designing tables/relationships like the Excel spreadsheet.
Arvil suggested a 3rd table. I would modify the design to be
tblRacks: RackID_PK, RackType, RackNumber, RackDescription;
"RackType" would be Source or Destination.
Have you drawn/designed the dB on paper/cardboard/the window/...??
"Old Programmer's Rule" is this: If you can't do it on paper, then you can't do it in Access. Until you can draw out your tables AND rules for how they change for each function you want to perform, you are going nowhere fast.
Originally Posted by
drunyan0824
A concern that I have is how would I create reports that only pull up a certain category? When I am using the reports wizard I have to select a field from a table. So if I use the CategoryName field from the tblWireCategories table, would that just give me a report with every wire from every category?
You have ONE report for any selected category. But you could have other reports with different formats to display the data in different formats.
You would set the criteria (the WHERE clause) to the category in a control on a form for the report record source (a query)
The query MIGHT look like:
Code:
SELECT tblWireCategories.CategoryName, tblWireInformation.WireGauge, tblWireInformation.WireNumber, tblRacks.RackNumber, tblRacks.RackDescription AS SourceRack, tblRacks.RackNumber, tblRacks.RackDescription AS DestinationRack, tblWireInformation.DrawingNumber
FROM tblWireCategories INNER JOIN (tblRacks INNER JOIN tblWireInformation ON (tblRacks.RackID_PK = tblWireInformation.DestinationRackID_FK) AND (tblRacks.RackID_PK = tblWireInformation.SourceRackID_FK)) ON tblWireCategories.WireCategoryID_PK = tblWireInformation.WireCategoryID_FK
WHERE (((tblWireCategories.CategoryName)="RF"));
On a form, you could have a combo box to select the "Category" (any one of the 18 categories) that would limit the report to the selected category.