Input Data Form

[Danny]

Dear all

If I have 2 tables in the databases, Table A & B. Table A is the transaction record while Table B is the customer Address
If I use a input form to add a new record to Table A and fill in the customer number, I want the address shown in the form and map to Table A. How can I do this?

 

[Wayne Morgan]

Create a query with both tables. Make a link between the two tables on the
common ID field. To do this, drag and drop the field from one table to the
other. Include the fields you want to see in the bottom part of the query
grid. Use the query for the form instead of a table.

--
Wayne Morgan
Microsoft Access MVP

Dear all,

If I have 2 tables in the databases, Table A & B. Table A is the

transaction record while Table B is the customer Address.

If I use a input form to add a new record to Table A and fill in the

customer number, I want the address shown in the form and map to Table A.
How can I do this?

 

[Danny]

Hi Wayne

I try to do what you suggest, but the problem is the new record cannot be added if I select the query for the form intead of a table. is there any solution

----- Wayne Morgan wrote: ----

Create a query with both tables. Make a link between the two tables on th
common ID field. To do this, drag and drop the field from one table to th
other. Include the fields you want to see in the bottom part of the quer
grid. Use the query for the form instead of a table

--
Wayne Morga
Microsoft Access MV

Dear all

transaction record while Table B is the customer Address

If I use a input form to add a new record to Table A and fill in th

customer number, I want the address shown in the form and map to Table A
How can I do this

 

[Wayne Morgan]

The first thing to check would be to try and add a record or edit an
existing record directly in the query itself to make sure that the query is
"updateable". If you can't, then this is why you can't do it in the form
either. If this is the case, go to SQL view for the query and copy and paste
the SQL here.

--
Wayne Morgan
Microsoft Access MVP

Hi Wayne,

I try to do what you suggest, but the problem is the new record cannot be

added if I select the query for the form intead of a table. is there any
solution?