I have searched all over for a fix or an idea how to go about this, I am sorry in advanced if what I am trying to do and how I explain it sounds wonky.
Back Story
Database with multiple tables, which I feel I have multiple with redundancy. Example... I have a table for New Computers and one for Old Computers. I do feel I should just have 1 table, and a column that marks it old or new.
I have a technician form that we give to the tech's to take to the jobsite. on it has The new PC Number and the Old PC number. These are input by the scheduling person back at the office.
Is there a way to have a merged table of New Computers and old Computers into just Computers and have another column to annotate new or old.
Which brings my dilemma of the new pc textbox and old pc textbox.
Can I have a textbox that if filled in adds a new record to Computers with the PC Number that is entered, and autofills the new/old column based on the textbox that is filled in?
Also having another textbox with the same thing except it would make a new record labeled Old?
Sorry if this sounds confusing. Let me know if there is any other information I could provide to make helping me easier.
Back Story
Database with multiple tables, which I feel I have multiple with redundancy. Example... I have a table for New Computers and one for Old Computers. I do feel I should just have 1 table, and a column that marks it old or new.
I have a technician form that we give to the tech's to take to the jobsite. on it has The new PC Number and the Old PC number. These are input by the scheduling person back at the office.
Is there a way to have a merged table of New Computers and old Computers into just Computers and have another column to annotate new or old.
Which brings my dilemma of the new pc textbox and old pc textbox.
Can I have a textbox that if filled in adds a new record to Computers with the PC Number that is entered, and autofills the new/old column based on the textbox that is filled in?
Also having another textbox with the same thing except it would make a new record labeled Old?
Sorry if this sounds confusing. Let me know if there is any other information I could provide to make helping me easier.