Input Data Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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


Danny said:
Dear all,

If I have 2 tables in the databases, Table A & B. Table A is the
Click to expand...
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
Click to expand...
customer number, I want the address shown in the form and map to Table A.
How can I do this?
 
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


Danny said:
Dear all
Click to expand...
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
Click to expand...
customer number, I want the address shown in the form and map to Table A
How can I do this
 
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


Danny said:
Hi Wayne,

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