Autopopulate, then edit a lookup field ??
I have a shipping address section on an order entry form that auto-populates from a contacts table (via lookup fields). It brings the information in perfectly, but I would like to have it bring it ...
Forum Discussion
What I do in these cases is create override fields. Lookup fields cannot be edited in the child as you have discovered.
It takes three fields each for the pertinent fields. I'll use City as an example.
There is the City field you already have that is a lookup form the relationship.
Then you would add a City_Override field and a City_UseThisOne field. My choice of names for the example. You can call them whatever you want.
City_Override would be a Text field available to type in.
City_UseThisOne would be a Formula - Text field.
City_UseThisOne formula:
If([City_Override]="",[City],[City_Override])
--There are probably better ways, this is how I would do it.
It takes three fields each for the pertinent fields. I'll use City as an example.
There is the City field you already have that is a lookup form the relationship.
Then you would add a City_Override field and a City_UseThisOne field. My choice of names for the example. You can call them whatever you want.
City_Override would be a Text field available to type in.
City_UseThisOne would be a Formula - Text field.
City_UseThisOne formula:
If([City_Override]="",[City],[City_Override])
--There are probably better ways, this is how I would do it.