Ok I have a form I use to enter data into multiple tables. The form consist of forms I built for the tables Power, Location, Assets, PDU, and Network. There is nothing that is similar in the tables that can really link them together, my goal is to link them all together in the Form and if a item is delete it deletes it across all the tables. I was hoping to use autonumber to link all of them together but I seem to be having a rough time grabbing the concepts of the relationship system in access. Any help would be greatly appreciated, I have teamviewer if someone wouldn't mind taking some time to help me make some sense of this, hard to explain what I'm doing without showing it. Thanks all.
Edit..
I attached my file if anyone wants to look at it, I want to link the tables Power, Location, PDU, and Network to Assets if possible.
Not sure how to attach files here but here's a link to my box account https://app.box.com/s/9cjn3xkc2gqbp6vl4p9y .