Search record

[jvande]

I have a two tables with the following relationships.

Many joined by DistID One
Customer Table Distributor Table
CustID DistID
CustName DistName
DistID DistAddress
Now I want to create a form that allows me to edit an existing Distrubotor. So I have it prompt the user to select an existing Distrubutor and then it goes and brings up that distributor record with the Distributor ID that matches the Distributor name selected by the user. Unfortunetly when I try to edit the information it won't let me because it says it is bound by DistID. I understand why it says that but how do I go about searching distributor and having the capability to edit a record?

Thanks, You all are great,,
Josh

 

[lasren]

if you take the properties for the combo box and either change the order of the fields in the look up or make the field name be bound. That should let you write to it. I don't know if it will allow for updating but you should be able to edit.