Let me make my question more clear

[deepak]

Hi!
Is there a way and How can I access are two different questions. Please
go through question and you will find the difference. let me make my question
clear by another example. Say, I make two table tblEmpInfo and tblSalaryInfo.
Both table are in relationship with a field EMPID. Now the question is
1) How access(view) the fields and its values from both the tables
tblEmpInfo and tblSalaryInfo in text boxes in a single form?

2) Is there way to store vlaues in the fields of these two tables at the
same time from a form? i.e. a form with different text boxes of where after
inseritng values , the values will be stored in the concerned tables.

 

[Arvin Meyer [MVP]]

Hi!
Is there a way and How can I access are two different questions. Please
go through question and you will find the difference. let me make my
question
clear by another example. Say, I make two table tblEmpInfo and
tblSalaryInfo.
Both table are in relationship with a field EMPID. Now the question is
1) How access(view) the fields and its values from both the tables
tblEmpInfo and tblSalaryInfo in text boxes in a single form?

You may be able to do it with a form based upon query which includes both
tables. My guess, however is that your Salary info table is a many-side
table meant to show multiple records as the salary changes through the
years. If not, it could probably be handled adequately with a single table.

2) Is there way to store vlaues in the fields of these two tables at the
same time from a form? i.e. a form with different text boxes of where
after
inseritng values , the values will be stored in the concerned tables.

If it is a many-side table, then a form and a subform are the way to display
the information and update both tables.

 

[BruceM]

The difference between the two questions is not clear, at least to me, but
more to the point you posted the identical question in two different groups,
and have started another thread without responding to or even acknowledging
the replies you received. You may not like the replies, but newsgroup
etiquette suggests you either clarify in the original thread, or state that
you have started a new thread.

 

[Keith Wilby]

more to the point you posted the identical question in two different
groups, and have started another thread without responding to or even
acknowledging the replies you received. You may not like the replies, but
newsgroup etiquette suggests you either clarify in the original thread, or
state that you have started a new thread.

I think what we have here is a loose canon. I shall be ignoring it from now
on