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

Is there a way? 7
How can I access data? 2
Access form continuous 1
Adding data to MS Access from csv file 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
New computer, how do i move outlook 365 ENTIRELY? 0
Dealing with a Pivot Table (when I don't want to) 0
Combo or list box 0

Top