Need help with my relationship.

[lccrews]

Hopefully that title made you chuckle... I have a field called 'potency' which resides on a master table. On the child table I have the same field listed. I'd like to have my query set to pull information from the master table 'potency' as a general guideline so to speak, but allow the user to update that value and append it to the child table and not the master table. I don't know how to do this or if it's possible. Is this a relationship issue? Right now, I have the query pulling 'potency' from the master table and other fields from the child table. Problem is, when the user updates the potency value, the master table's value is updated.

[RuralGuy]

Have you tried putting the "child" table in a SubForm?

[ranman256]

you run a query. Either an append query to add items to the child table,
or and update query to put potency in an existing record.

This is NOT a relationship. The parent /child tables are bound by MASTER.KEYid.
This potency seems to be an extraneous field, unless each record in the child table is a dosage and requires a potency.

Either way, youd use a query to update the field value.

[lccrews]

Ranman256 I get the idea you have I just am not sure of the execution. Would I draw the two tables together via query (to get the 'pre-filled potency') and then use a button to update the child table with values from this subform? The goal is to have a table on a form as a subform, and the users input information to update it.