Lookup Value List Keeps Growing

[MatthewB]

I have a lookup on a foreign key that associates a strata to a task. So I use the lookup to provide a strata plan nr. It seems with each new record I create and assign a strata plan nr my value list grows by one value of that nr. Is there a known cause for this?

 

[theDBguy]

Not sure I follow. Can you post your table structure?

 

[June7]

By 'lookup' do you mean a combobox? What is combobox RowSource? If you want to provide db for analysis, follow instructions at bottom of my post.

 

[MatthewB]

T

 

[MatthewB]

ELECT StrataPlan_T.kp_StrataPlan_ID, StrataPlan_T.StrataPlanNr FROM StrataPlan_T INNER JOIN Quoting_T ON StrataPlan_T.kp_StrataPlan_ID = Quoting_T.kf_StrataPlan_ID ORDER BY StrataPlan_T.StrataPlanNr;

 

[June7]

Neither of those posts help me understand your database structure nor behavior.

 

[Mike Krailo]

Why is there duplicate data in your combo box and what do those codes represent? What exactly is a strata plan? Something doesn't look right but it is made even more difficult to decipher when only shown a small portion of the form. Show the table structure and the whole form for context. Usually duplicate data is OK if you are grouping items together based on a classification of some type as long as the unique values are in another table but in your case the data in the dropdown shows duplicates which suggests that there are unique ID's that are stored but the displayed value could be the same. Not sure what to make of it yet.

It seems with each new record I create and assign a strata plan nr my value list grows by one value of that nr. Is there a known cause for this?

My guess is a problem with table structure so need to see what you have to be of any help.

 

[moke123]

have you tried "Select Distinct ..."

 

[MatthewB]

I will strip out my db and upload. Thanks. Tonight. PST

 

[MatthewB]

I solve the problem.
I need to delete the relationship between kp and kf StrataPlan, delete the row soure for the look up. recreate the look up and then creat a one to many between the Kp & kf StrataPLan. Now my lookup does not show duplicates of my strata plan nrs. stratas are condominium buildings. Does one need to make lookups before creating one to many relationships? Maybe deleting the lookup and recreating it might have sufficed.