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

How to update linked child in subform when master field has changed?

P: 1
I am new to this. I have a master form with OrderID and ScaffoldID linked to a Child form for data entry. Child form has product information in each record. I have a need for users to be able to change OrderID and ScaffoldID when editing the order. I want to udpade OrderID and ScaffoldID in child form without changing any product information already entered. I got stuck on this. Please help.
Jan 31 '08 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I am new to this. I have a master form with OrderID and ScaffoldID linked to a Child form for data entry. Child form has product information in each record. I have a need for users to be able to change OrderID and ScaffoldID when editing the order. I want to udpade OrderID and ScaffoldID in child form without changing any product information already entered. I got stuck on this. Please help.
Firstly, it is unusual to have more than one child link on a subform and it can cause problems. Secondly, if you link on these ID's then you can't change them in the subform. I think your problem has more to do with the structure of your tables and their relationships.

Check out this tutorial ...

Database Normalization and Table structures
Feb 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.