By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,665 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Data input and tables

P: n/a
Don
I have two tables, table A and table B. Both tables have fields called
"Income". How can I add data to table A and have it automatically entered
in table B? I've tried the relationship builder but I've never really used
it because I don't know how.
Is there a way to enter data into a field in one table and have the same
data show up in another table with the same field?
Thanks,
Don...............
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
msg
Here's a simple solution. If you are entering the information using a
form you can do the following to get the results you want. First
create a macro to update "income" from table A to "income" in table B.
Then on the data entry form for table A go into the properties on the
"income" field and create an event "on lost focus" to call the Update
macro you created earlier. That way everytime you enter something into
Table A Income as soon as you are done typing and move on to another
field in the form or another form altogether, Table B will be updated.

Don wrote:
I have two tables, table A and table B. Both tables have fields called
"Income". How can I add data to table A and have it automatically entered
in table B? I've tried the relationship builder but I've never really used
it because I don't know how.
Is there a way to enter data into a field in one table and have the same
data show up in another table with the same field?
Thanks,
Don...............


Nov 13 '05 #2

P: n/a

Don wrote:
I have two tables, table A and table B. Both tables have fields called
"Income". How can I add data to table A and have it automatically entered
in table B? I've tried the relationship builder but I've never really used
it because I don't know how.
Is there a way to enter data into a field in one table and have the same
data show up in another table with the same field?
Thanks,
Don...............


Don,
is there a reason you need the data in both tables? You can join table
A to table B in a query... Explain what your business rules are or what
kind of rule you're trying to enforce. Maybe you're making your job
more difficult than it needs to be.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.