Hi,
I have a form which is a data entry form for inputting details about received products in a technical support department.
there is a combo-box which is used to select the Sender of the product. I already have a table for senders and this combo-box queries its content from that table.
in my senders table, each sender has a unique ID. although in the form you just select the sender based on their name not ID.
I also want to have another field on the form which is the Inquiry ID, and I want it to work like this: when the user selects the sender from the combo-box, The inquiry ID must be filled automatically based on this formula ==> selected sender ID/Current date.
so If the user selects Mr. Smith as the sender and Mr. Smith's ID is 2850, the Inquiry ID should look like this : 2850/1012012
how Can I get that Inquiry ID field calculate this value based on the selection the user has made on the Sender field?
I really appreciate your help friends.
I have a form which is a data entry form for inputting details about received products in a technical support department.
there is a combo-box which is used to select the Sender of the product. I already have a table for senders and this combo-box queries its content from that table.
in my senders table, each sender has a unique ID. although in the form you just select the sender based on their name not ID.
I also want to have another field on the form which is the Inquiry ID, and I want it to work like this: when the user selects the sender from the combo-box, The inquiry ID must be filled automatically based on this formula ==> selected sender ID/Current date.
so If the user selects Mr. Smith as the sender and Mr. Smith's ID is 2850, the Inquiry ID should look like this : 2850/1012012
how Can I get that Inquiry ID field calculate this value based on the selection the user has made on the Sender field?
I really appreciate your help friends.
