Ok I'm running into a small problem here.
I have set up a small database to eliminate our end of shift report paper trail.
I have a table with our techs, a table with the lines that are worked on and a table with the problems common to those lines.
I want to keep my form simple and less prone to user error by having a couple combo boxes. The main problem I'm running into is this. I have a combo box which lists the names of the lines we have. Now when you select a line and start entering in data, every time I go back and check the table data, the database is entering in a new record for each time that line is selected. The same goes for the tech table, a new record is being created each time a tech is associated with a line.
Is there a way around this? Seems to me if I continue like this my database will get bloated pretty quickly with unneeded records in the line and tech tables.
Thanks in advance
I have set up a small database to eliminate our end of shift report paper trail.
I have a table with our techs, a table with the lines that are worked on and a table with the problems common to those lines.
I want to keep my form simple and less prone to user error by having a couple combo boxes. The main problem I'm running into is this. I have a combo box which lists the names of the lines we have. Now when you select a line and start entering in data, every time I go back and check the table data, the database is entering in a new record for each time that line is selected. The same goes for the tech table, a new record is being created each time a tech is associated with a line.
Is there a way around this? Seems to me if I continue like this my database will get bloated pretty quickly with unneeded records in the line and tech tables.
Thanks in advance
