My database basically tracks computers given out to individuals.
I originally had a many to many relationship where there was a hardware table, recipinet table, and a hardware & recipient table, which relates the two prior tables. I run into trouble trying to add hardware to recipients and vice a versa on my forms (front-end). To better explain: I have individual forms for hardware and recipients with buttons to view the recipients and hardware where appropiate; however, when I attempt to add either (recipients or hardware) the changes are not reflected in the hardware & recipient table, but they are added to the hardware and recipient tables individually.
I'm trying to keep the database normalized, but I just can't solve this problem.
Could anyone help?
Nicole
I originally had a many to many relationship where there was a hardware table, recipinet table, and a hardware & recipient table, which relates the two prior tables. I run into trouble trying to add hardware to recipients and vice a versa on my forms (front-end). To better explain: I have individual forms for hardware and recipients with buttons to view the recipients and hardware where appropiate; however, when I attempt to add either (recipients or hardware) the changes are not reflected in the hardware & recipient table, but they are added to the hardware and recipient tables individually.
I'm trying to keep the database normalized, but I just can't solve this problem.
Could anyone help?
Nicole