How can I access?

D

deepak

Hi!
I want to know to code to access data of two different tables in a
single form? Let me make my question clear by an exaple--- suppose I make two
tables tblName and tblAge. In tblName I have two fields say name and address,
and in tblAge I have two another fields age and telephone no. Please help me
to know how to desing a form to access all the fields from the both tables in
four text box, i.e. in one form I am able to view the values of name,
address, age and telephone no.

Thanking you all.
 
R

Rich

I have done this by creating a query that will show information from the 2
tables, then creating a form which has that query as the datasource.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I access data? 2
Is there a way? 5
Can't add records to statement with two many-to-many joins. 3
Blank shows in combo when there is an excluded record 2
How to insert fields of different tables in one form? 2
Multiple tables search 3
Adding fields to forms 3
SQL Change Column name 5

Top