Hello Derek,
thanks, I truly appreciate it. I was impressed with your first example but was not immediately able to understand how the filter worked but I see it has an items table field in the service table and I think that is the key to how this works. I have to go out on a job now but look forward to looking at your new example and I will report back to you later. I am in New Zealand.
Thanks and regards, David.
151 2016-01-27 23:22:32
Re: Filter a table that has already been opened (6 replies, posted in General)
152 2016-01-27 22:22:02
Re: Filter a table that has already been opened (6 replies, posted in General)
Derek,
your approach is that you record each item (eg a fridge) and its main details only once and then a service event is recorded for that item.
My application books the item each time it arrives for servicing and this involves recording the model and serial number etc although it is made easier with the use of drop down boxes. I like your approach and need to think further about my design and how the client will use it.
I am intending for the current application to go into service over the next month or so using MySQLite and then start the process of upgrading it to MySQL Community Edition for install in the second half of the year. I have never MySQL either. There are potentially 15 users with the data stored on a server but the likelihood of simultaneous edits of a record is negligible.
Thanks again for everything, David.
153 2016-01-27 20:46:40
Re: Filter a table that has already been opened (6 replies, posted in General)
Gentlemen, thank you for the responses. I had to send the whole project to the Drive email address as the client has commercial sensitivity with the project. I hope that is ok.
Thank you Derek for the sample. I will be studying it over the next few days. I really appreciate it.
I got MVD late last year and am using version 2.2 and am wondering if I am best to now be using 2.3.
There is a lot to like about MVD and when I have a bit more experience I will write a post about it.
Thanks again, David.
154 2016-01-27 02:31:18
Topic: Filter a table that has already been opened (6 replies, posted in General)
Hello all,
I am new to MVD and this is my first project so please keep this simple. I need to demo this to the client in a week or two.
The application keeps a record of service jobs on electronic equipment. The item is booked in recording its model, fault, serial number etc etc. I have a table grid which shows the list of jobs and I use the new record action on a button to add a new record.
Next to the "Serial Number" edit box field on the booked job form I have a button with the caption "Check History" on it. This button uses a action to open another form which has a table grid and I have attempted to have a filter on the action form which limits records displayed to previously entered records with the same serial number as the new job booked in. This allows the user to see previous service history of an item arriving for servicing.
I am having loads of trouble making this work. Because the table is already opened to add the new record, is there a limitation that I cannot open the same table in another form at the same time.
I hope that makes some kind of sense.
Thanks in advance,
David
155 2015-11-16 03:20:50
Topic: Serial port (0 replies, posted in General)
Hello,
I have been looking at the trial version and am interested but would like to send/receive data over the RS232 serial port. Has anyone tried that.
Thank you.