can i use a queries or not

[AlaaB]

Hi guys
i have a little Q

i have created table number 1
contain
Account number, Description, Status and Code


and i have created table number 2
contain the same mention fields above + lots of fields such as date and price and paid not paid etc

and the Q is how can i make the table number 2 take the data from table number one as soon as i select the account number or account name from the combo box that i create on the form

i need the table no 2 to take only the (Account number, Description, Status and Code) from the table number 1

sure the table 1 has data and its read only i don't want to edit it

waiting your kind support

thanks in advanced

 

[SteveSchapel]

Alaa,

This appears to be almost identical to another post from you with a different subject title.

 

[AlaaB]

that's right dear
because i thought that i register it at the wrong type
cuz lots of guys pass through without any reply
that's why i did that

 

[jal]

Oh, I see. The other thread is here:

http://www.access-programmers.co.uk/forums/showthread.php?t=196831