Fetch data from table and display inform and insert to another table

[baijuep]

Sir, i am new in MS Access i had worked in asp.net. but now i want some help in access.


I have a small access database in which i have a form there is a barcode field when barcode is fired to that barcode field a query should run to fetch the data of that particular person from table named MAIN and display in the fields in the form and the entire data to be inserted into another table naned enterkot.
My table structure is as under


MAIN (Table)


id autonumber
No text
tank text
Name_ text
Barcode text


ENTERKOT (table)


id autonumber
mid number
No text
Tank text
Name_ text
Barcode text
Date_ datetime

When i open my form name enterkot there are all fields to enter data.
1. When i click my barcode and the barcode is entered into barcode field.
2. On text change the data should pickup from table main and display in form
3. In form there is a field named date the date should be the computer date
4. After displying the data in form it should automatically stored in table ENTERKOT


please guide me i am new in access

[June7]

Why do you want to save this data into another table - that looks like duplicating data.

Appears you need a better understanding of relational database principles and could benefit from working through a tutorial. Try this one http://www.rogersaccesslibrary.com/

Date is a reserved word. Should not use reserved words as names.

[baijuep]

Why do you want to save this data into another table - that looks like duplicating data.

Appears you need a better understanding of relational database principles and could benefit from working through a tutorial. Try this one http://www.rogersaccesslibrary.com/

Date is a reserved word. Should not use reserved words as names.

I don't want to duplicate the data . I want the id and barcode to be stored in another table so that i can check howmany times did a person visit that room.

[June7]

Then what did you mean by 'entire data'?

Don't need both ID and barcode saved.