How can I access data?

[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.

Thanking you all.

 

[Maurice]

First of you should not cross post your question and post your question once
(Is there a way? is the same question).

Furthermore I think you should rethink your strategy ofcourse there will be
some magical way to get this done but you should consider setting up a
correct tablestructure with relationships.

 

[Keith Wilby]

First of you should not cross post your question and post your question
once
(Is there a way? is the same question).

Furthermore I think you should rethink your strategy ofcourse there will
be
some magical way to get this done but you should consider setting up a
correct tablestructure with relationships.

Agreed. Age has no relationship with phone number and, even if it did,
you'd be better off storing "date of birth" and calculating age in a query.

Keith.
www.keithwilby.com