How can I access data?

  • Thread starter Thread starter deepak
  • Start date Start date
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.

Thanking you all.
 
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.
 
Maurice said:
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.
Click to expand...

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
 
Back
Top