Hi,
Is there a way to search data using a calculated data field.
On 'EntryForm', name, address, contact, date(Dt) and serial number(Sr) are entered which are combined to produce a calculated result using formula -
Year[Dt] *10000000+Month[Dt]*100000+Day[Dt]*1000+[Sr]
There is a separate primary key with autonumber is present, however the result of this calculated field is supposed to be unique for each entry as serial number for two entries can't be same on a same date.
On 'DataForm', Date and serial number are to be entered by user in combo boxes and text boxes. The
above calculation would be done in background using same formula. This should be used to search table connected with 'EntryForm' and after matching, other data of the same customer, i.e. their name, address and contact number should be displayed in text boxes.
Can someone help me how to do this.
I have tried to use a query but it says that calculated field can't be entered.
Any help would be appreciated.
Is there a way to search data using a calculated data field.
On 'EntryForm', name, address, contact, date(Dt) and serial number(Sr) are entered which are combined to produce a calculated result using formula -
Year[Dt] *10000000+Month[Dt]*100000+Day[Dt]*1000+[Sr]
There is a separate primary key with autonumber is present, however the result of this calculated field is supposed to be unique for each entry as serial number for two entries can't be same on a same date.
On 'DataForm', Date and serial number are to be entered by user in combo boxes and text boxes. The
above calculation would be done in background using same formula. This should be used to search table connected with 'EntryForm' and after matching, other data of the same customer, i.e. their name, address and contact number should be displayed in text boxes.
Can someone help me how to do this.
I have tried to use a query but it says that calculated field can't be entered.
Any help would be appreciated.