Search results

Couple of reasons why this way should work best for us. 1. Only 2-3 people will have access to the database. These people will have intimate knowledge of both the database and each project they are working on. Only they would be putting in data. The data base is being developed in stages and a...

Hello, I need to know how to link multiple backends to one front end. How to let a user select on a form which backend they want to put data in. I have created a database for my department. It will be used for different projects. The tables and user interface will be the same for each...

Because conduits hold multiple wires and each duplicate is a wire number (1,2,3,...). That is why I included this in the SQL QryTerminationA.ConduitFK)=[QryTerminationB].[ConduitFK]) AND ((QryTerminationA.WireNumber)=[QryTerminationB].[WireNumber]

I found the solution, but due to a time crunch I am only now able to post it. I needed to write the SQL to create the solution not change the tables. Changing the table to have keys or to/from creates issues down the line for what we need the data for. Here is my solution: The tables and...

Thank you for replying. I do have Junction tables. The naming is different but Asset = Equipment and JT =Junction Table. Also, I know that the spaces need to be removed from the fields... long story. There can only be two pieces of equipment to one conduit. One Piece of equipment can have...

I am sorry if my title makes little sense, I am learning Access as I go and I do not have all of the vocabulary. I will try to explain but I think the pictures I have will work better. I am trying to show that two pieces of equipment are connected by the same conduit/wire (see drawn pic). I...