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

record update to a record in another table..?

P: n/a
Hello,

I have a form linking two tables but they have one field that is
shared called "device" I want to allow data input into one of the
fields and hide the other (so I need it automatically updated from the
first record). How do I have the second record in the separate table
updated based on the change or update of the first record?

I am probably missing something really stupid and easy!

Hope I explained that clearly!!

TIA

J.B.>
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 9 Jul 2004 00:16:00 -0700, st*****@excite.com (Joe Bloggs) wrote:
Hello,

I have a form linking two tables but they have one field that is
shared called "device" I want to allow data input into one of the
fields and hide the other (so I need it automatically updated from the
first record). How do I have the second record in the separate table
updated based on the change or update of the first record?

I am probably missing something really stupid and easy!

Hope I explained that clearly!!

TIA

J.B.>


Your data structure is not normalized. You should store the data in
field "device" in only one table.

- Jim
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.