Access 2007 Table Trouble

[rhodes92]

Basically what I am trying to do is I have two tables set up one for my Invoices and one for my Accounts receivable and what I want to do is bring the information from the Invoice into the table for AR without having to retype all of the fields that are the same, such as the invoice total, GST, etc...

How I would like it to act is when I add a new invoice to the tickets table I would like the AR table to generate a new record with that ticket number and populate the fields that are the same in both tables, I have defined a relationship between the tables but can't seem to find a way to get the data over there without re typing.

I am thinking that there must be a way to do this but I am new at access so I came here for some help. Thank you

 

[jdraw]

Just a thought for consideration:

If you have a business and need to do various accounting/financial functions, you may find that a commercially available package -with documentation, a user group, technical support and training may be an option worth considering.

I'm not trying to dissuade you, just making sure you have given some thought to an alternative.

Good luck with whatever you decide.