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 you will want to do is make an "Override" field.
Do do this you will need to make 2 new fields on the "Order" table.
(1) Order Address (formula-text field)
(2) Change Address (Address field)
The formula logic for the "Order Address" will be:
If([Change Address]<>"", [Change Address], [Lookup Address])
Basically if you decide not to override the lookup address by leaving it blank, it will use the default, otherwise it will use the changed address.
You can break this out to all the individual components on an address field. which is useful in situations where you only need to change one line of the address, like an apt #.
Do do this you will need to make 2 new fields on the "Order" table.
(1) Order Address (formula-text field)
(2) Change Address (Address field)
The formula logic for the "Order Address" will be:
If([Change Address]<>"", [Change Address], [Lookup Address])
Basically if you decide not to override the lookup address by leaving it blank, it will use the default, otherwise it will use the changed address.
You can break this out to all the individual components on an address field. which is useful in situations where you only need to change one line of the address, like an apt #.