Create new record in a table not linked to a form

[silva]

I have two tables in a database. One is attached to a form in which I do
utility calculation, and the other is for generating billing statements. I
can't link them properly as each record in the calculating table is for a
group of payees (everything is submetered off of main meters), and the other
table has one record per payee in order to properly generate a bill with a
report. Due to the nature of the way things are I can't see a way to properly
do this with one table or even be able to adequately link the tables so that
I could pull everything into the form. Is there a way to create a command
button that'll create a new record in the other table? If I can achieve this
then populating the fields is easy. Or is there a way to possible reorganize
it so they can be linked?

 

[silva]

I'm sorry, I figured this all out. I was able to create a central table and
linked everything off of it. When I took a few minutes to think about it, it
was pretty obvious what I had to do. Sorry to waste your time reading this.


--silva