No. I need two tables unfortunately. I'm trying to learn access for my job and one example I was given is that sometimes there's extra information that they don't want included in the main table because the main table is only for admins. The secondary table would provide additional information on a record for those who would actually work with the project (record). So I need to make sure every record has a matching record that can be edited and seen...

I'm new to access and am wondering if this is possible. Basically, I have a main table where the majority of info goes. But then there needs to be a second table with additional information. I want to make it so every time a new record is added to Table A, a blank record also gets added to Table B, so that when editing in a form, the user can have the option to click a button and see that additional info.

That, or is it possible to...