Filling in a table via a form

[janjan_376]

I am just trying to learn Access. Please help me on this scenario:



- I have the following tables: SenderTbl and ReceiverTbl
- no Query and relationship has been created yet ( I am not sure if I should create them to make my project works )
- I would like to create a form, which would be use to enter information for a new receiver, that has:

Combo box : in which I can select the Sender ID from the SenderTbl
Textbox1, Texbox2, Textbox3 would then have the ID, Firstname, Lastname, respectively, of the ID selected in the Combo Box

Textbox5...so on : that would accept info such as firstname, lastname, phone numbers of the new receiver.


All these entered info in the textboxes should be then stored in a table called ReceiverTbl.

Please help. Thank you in advance.

[ali-gagi]

Hi
so why you need the combo, textbox1, ... and textbox3? is there any relation between receiver and sender in cosept?i mean why those feilds are suppose to be fill in one form?
i think source of your form should be a query which have all feilds you want to be in your form.