Girard Aquino wrote:
Drew Jensen wrote:
Clifton Liles wrote:
Drew Jensen wrote:
Drew Jensen wrote:
Girard Aquino wrote:
Basically, what I want to happen is:
- client approaches staff and asks for supply
- staff enters ID number and if
- client already has an entry in database, staff just adds the
new supplies the client needs which goes to the SUPPLIES table
- client is not in database, staff creates a new entry in the
CLIENT table and enters supplies given accordingly.
Actually you are quite close to having what you want. There is a
problem with your tables with regards to the relationship link
between them but after that most of the functionality you want is
already thee in the Base application.
.... I do have a comment on the DB design. If I was doing this I
would like a third table of supplies.... As it is ...you could get
several different names for one item ... What I would like is , if
the field has a value, that value should be displayed, if there is
no value, then a drop down list of values.
What do you think Girard?
Is this the first (next) change you would make to this database?
. .... for my purposes ... is for a shelter which does not necessarily
have to monitor stock of supplies - just how many and what were
given....What we needed to accomplish is making sure that people
aren't asking us for razors everyday for example.
Hi Girard,
Ok - well then let's take a moment and look at the single form again
- with your particular usage in mind
- 0 keeping Cliff's good remarks in mind at the same time.
So I went ahead and made a few changes to form.
Added seven controls - six of which are visible - and changed properties
on the a few of the existing controls.
The focus for the changes was in these areas:
1 - Make it easier to work with the form - with or *without* a mouse.
2 - Address the question of data integrity - specifically the 'item' values.
3 - Talk a little about the current choices for searching and filtering
the data.
Oh and I did read on doing macros and it's seems to be a good idea as
well.
Wonderfaul - cause I added a single macro.
Well - the form is not exactly right - least not how I would finish -
but as it sits on my disk this moment it is getting close. (to my vision
of done at least)
You can find the new form, the old form, the single macro and ~16,000
client records in this file: (~601K)
http://baseanswers.com/downloads/oooSupplies_shelter.odb
The next email here I'll go over 'each change' - but before that if you
grab the file some notes:
The macro requires OO.o 3.1 in order to run as it is embedded in the file.
You can use the database and the form without the macro functioning.
Either because you do not have version 3.1, or you simply don't enable
macro execution
- the only loss will be the UI not updating properly when a new item is
dispensed to a client.
[which means if you dispense an item, then move off the record and back,
then and only then will you see the dispensed item in the History grid]
The form now includes a top level menu, 'Supplies', with a single menu
item. The menu will not display if you do not have OO.o 3.1.
If you do have OO.o 3.1 the menu will display and will not function - Oh
joy.
Actually the last 'little' change to the form caused that menu to
disable and stay disabled...The Base form designer does have a
personality all it's own..lol
- In fact that was the moment that I decided to post this file - cause
in the next email I'll look at why that stopped working and how we get
it back...I hope.
Alright then (and as my nephew would text)
G2GFN - BRB
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
