Search options (Page 87 of 104)

Hi Dmitry,
This is great - it does exactly what I want it to do now - I think this is going to be very useful in a lot of other applications.
Many thanks for your help.
.
Hi EHW,
Thanks for your interest and the alternative suggestion - I've not seen this sort of 'hot spot' clicking (for want of a better description) used in MVD before.  I think this, together with Dmitry's response using 'Get RowAtPos' is going to create new and interesting ways of designing tablegrid interactions for me.
.
Derek.

Hi,
This usually happens if you do not close the current form after saving;  closing the form is the easiest way to prevent this from happening.
However, if you need to keep the form open after saving, you can clear the fields (with a script);  you should also set one or a number of the form fields to be mandatory (to prevent  further problems with blank records being created).
Regards,
Derek.

Hi David,
Thanks for the project.  I made a couple of changes that I hope address the points in your original post and then made one or two alterations as they occured to me going through it.
1.  I added a relationship between the items and the purchaseorder tables so when you add items, it automatically adds the tracking number to maintain the relationship.  This works whether you add items at the same time as adding an order OR if you add an order, save it and then add items at a later stage.
2.  I changed the search comboboxes on the purchaseorderlist form to be incremental so the user doesn't have to click 'search' (now hidden).  This gave me some space so I added a 'clear all' button to save users having to clear  the combobox searches individually (I know, we spoil them too much!!).
3.  Branch was a combobox dropdown on the purchaseorderrecord form so I added it as a combobox search on the purchaseorderlist form as well
4.  I added running totals to all the tablegrids
5.  The 'total price' field on the item form now calculates automatically
6.  I added a couple of calculated fields so you can a) see what the running total of all 'tracks' is on the purchasorderlist form and also added a flag to show whether there are any notes.
There wasn't much to do in the script but where there was, I've commented it so you can easily change/remove it.
Hope some of the above helps,
Regards,
Derek.

Hi Manixs,
Please have a look at the attached example.
I am not sure if you want to color the whole row or just the cell so I have shown both ways.
The condition for colouring can be any value from any column that has been defined to the tablegrid (even if the column is made invisible, as I have done in this example).
Hope this helps,
Derek.

Hi Nitin,
I would use a calculated field with substring to reformat the date to how you need it to appear in the tablegrid.
Have a look at the attached example;  it's not very sophisticated, but it works!
Depending on how your date is held, you may need to adjust the substring parameters in the calculated field but the principle is the same.
Regards,
Derek.

Hi Terry,
If I'm understanding your question, I'm guessing that when you display your tablegrid, you get the first related field displaying properly but all subsequent related fields just display their record id.  When you relate 2 tables more than once, you need to use calculated fields to temporarily hold the extra related details and place those calculated fields onto your tablegrid.
Have a look at the attached example and see if this is the sort of thing that you are trying to do.
Regards,
Derek.

Hi DBK and EHW,
Also knocked up a quick demo project (see attached) - I clearly have too much time on my hands - LOL! 
I was trying to see how close it could get to the requirement without using any script but in the end I had to give in and add a few lines!!!
Anyway, hope it helps to move things forward for you.
Derek.

EHW - neat way how you toggle between the edit field and the combobox for the stock or non-stock items.  Just one thing - can you explain  what does the Prod_Lookup.TableGrid1.PopupMenu := nil;  line do?  It's not something I've come across before. 
Thanks.

Hi Mathias,
How's things?  Thanks for having a look.  I was approaching it  from the wrong end (see Dmitry's response).  You use the 'time' part of the datetimepicker field, define that as your database field and then link it to the 'date' part.  I wouldn't have thought to do it that way and it doesn't seem very intuitive but at least we know if we need to do something like that in the future.
Regards,
Derek.

Hello Dmitry,
Have you been able to have a look at this problem?
Thanks,
Derek.

Hi Adam,
The script was getting a bit messy so I've re-written some of the procedures and simplified them.  The problem you were encountering shouldn't happen now (yes, I know that's what I said before - LOL!). 
Derek.