Unanswered: Add records - pick from multiple tables
Hi there all,
I have a database which contains aircraft information. I have however got a lot of new information from the manufacturers which I want to store in a new table. I do not want to copy the forms and queries into another database and I was wondering if there was any way I can use the existing forms but pick which table I want the record to be added into and also with the viewing of the data have the option to pick the table I want to use.
You could also continue the single-table pardigm and simply append the new records into the old records table. By adding a field to that table, you could distinguish between the old and new records and use that field as a criteria in the source query for the form.
You could also add a pair of toggle buttons in an option group to your form, each indicating an association to a different table. In the AfterUpdate property of the option group you can switch the record source of the form.
Either method, IGelin's, or any of these methods will work fine.