@akhilpaul wrote:
Child table , have the column have the suggested value
if i give input other than populated or suggested value need to update the parent table value.
I assume by this you mean to update the Parent's actual value - not just the list of choices? Correct? If so, since a Parent can have many children, how does the Parent decide which Child value to use?
while we add purchase detail the rate may change time to time . whenever the rate change occur need to update the parent table value . so next time will suggest new value
I think you are saying that you want the Parent dropdown list to include any Rate values inserted for children. The next question is do you mean only from the Parent's children or from any children?
You want the Parent list of value driven by what is inserted on the child rows, so use the Child table as the source. If you are wanting values from ALL children then on the Parent Rate column use this expression:
UNIQUE(Child Table Name[Rate])
Replace "Child Table Name" with your actual table name. This expression will return a list of rate with NO duplicates. You can use this expression in Valid_If or Suggested Values depending on your need.
LinkedIn
Twitter
