How to make filled form from first form

[sumox]

i have two tables

Challan
Invoice

We create firstly challan by Challan Formname: ChForm

ChForm has following fields data which i want to copy into INVForm
based on Invoice Table

1. Challan No.
2. Date of challan
3. PO No.
4. Array of Fields like ItemSr.no , ItemName, Qty and UOM
5. Transporter name

WHAT I WANT : I create new record in Challan Table by using
ChForm then i just click on one button and all above data is copied
and INVForm opens --->New Record--->all data copies into similar name
field in INVForm and i can save it to create invoice
Note: There are other several fields in INVform in addition to above

WHAT DO I DO ??

I DONOT KNOW VBA
I KNOW ACCESS MACRO
I AM BEGINNER IN ACCESS WHO KNOWS ACCESS MACROS

PLEASE HELP ME IMMEDIATELY WITH EASY STEP BY STEP

 

[rodmc]

first off, demanding help is not going to assist your problem, secondly the aim of the forum is to educate as much as help.

Look into an update/append query!

 

[pr2-eugin]

Hello sumox, Welcome to AWF.

You do not need to Copy the field values across. What you need is proper Relationships. Google on Normalization. Refer to THIS Document. You will have a clearer idea. Again, you do not need to copy/replicate information in two tables.

 

[sumox]

Rodmc,

how shud i do?