I want to add a new table on my database but I want to use the form I already have to fill in the new table I'm adding. How do I do this? The new table I'm adding is a related table to my origianl table I have. Please help me!!!
If you just want to just use your original form to enter data to the new tabel, you simply need to change the 'Record Source' of the form to the name of the new table.
If your new tabel is sharing some of the form's data with the old table, then you could build a query from the two tables and make your form's 'Record Source' be that query.
I think the second one answers my question. But basically what I'm trying to is have the old form fill out the new table and the old table at the same time. Since the new table I'm putting in has some of the same info as the old one, I don't want to be entering it twice. Say for example my old table has a "student number" and the new table has one too. I want to be able to just enter the student number on the old form and it will fill out both of my tables. So, does your second option work on this?
Say for example my old table has a "student number" and the new table has one too. I want to be able to just enter the student number on the old form and it will fill out both of my tables.
You need to search the forum for posts related to database normalization as I think you have a data integrity problem here. If you db was normalized correctly and have established links between tables with referential integrity then you wouldn't need to fill in student number twice as filling in student number in a parent table would automatically place this value in related child tables...
